Scalegrid

APRIL 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 185

Database Cloud Open Source Azure 185

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. To find out what’s different and new about SQL Server 2017, go to this documentation page: What’s new in SQL Server 2017. SQL Server on Docker.

Servers 40

Servers Azure Open Source Database 40

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. The performance penalty is relevant only when the window function is optimized with row-mode processing operators. Figure 1: Plan for Query 1, row-mode processing.

Best Practices 108

Best Practices Servers Database Azure 108

The Symphonia

DECEMBER 6, 2017

We don’t recommend using this as a regular process for production use, but it might come in handy at development time. Despite the fanfare, therefore, AWS is still behind Microsoft Azure Functions when it comes to debug tooling. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for.

Serverless 40

Serverless Lambda AWS Traffic 40

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. SELECT * FROM Azure Cosmos DB – Andrew Liu.

Engineering 40

Engineering Azure Best Practices Servers 40

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) SQL Server can elect to use a parallel query to process the request.

IoT 61

IoT Servers Development Cache 61

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB. looking out for MongoDB Inc.

Open Source 83

Open Source Programming Database Servers 83