SQL Shack

OCTOBER 26, 2021

This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database. Introduction Azure SQL Database enables its users to focus on database objects, tuning queries without managing the underlying infrastructure resources. These indexes help the query […].

Azure 103

Azure Database Tuning Infrastructure 103

Scalegrid

MARCH 22, 2024

In this article, we will explain the multi-cloud challenges and explain how using multiple cloud services can make your business more adaptable, ensure that your operations continue without interruption, and help you control your spending. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 83

Open Source Programming Database Servers 83

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores.

Azure 55

Azure Database Serverless Hardware 55

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. PostgreSQL popularity is skyrocketing in the enterprise space.

Strategy 182

Strategy Cloud Java Open Source 182

SQL Performance

APRIL 8, 2020

This article is the first in a series about the fundamentals of table expressions in T-SQL. If you can bear with me a bit, I'll provide the reasoning for my view of things in this article. In my examples I'll use a sample database called TSQLV5. What is a table in SQL and what is the counterpart in the relational model?

C++ 143

C++ Azure Database Servers 143

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Database corruption happens unfortunately.

Servers 49

Servers Azure Hardware Database 49