Learn a few ways to improve performance in your Azure SQL Databases through better indexing, partitioning, and columnstore index consideration.
2025-06-09
2,566 reads
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
2025-06-02
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
2025-03-10
1,420 reads
This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.
2025-02-14
1,991 reads
In Azure SQL Database serverless edition, we get an upgrade to our configuration.
2024-10-12
111 reads
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-06-07 (first published: 2024-05-24)
1,426 reads
Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.
2024-03-30
407 reads
2024-03-29
7,002 reads
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).
2024-02-02
2,484 reads
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In its early days, it was missing several important features (like data compression). While that hole has been plugged, there are still other limitations and differences you should be aware o
2024-02-02
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Has the PK been used...
Comments posted to this topic are about the item Has the PK been used...
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers