Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]
Azure SQL
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]
The SQL Developer Experience: Beyond RDBMS
SQL Server has always empowered developers through a wide variety of drivers, the robust T-SQL language, and an […]
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance […]
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […]
Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]
Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]
Improve scalability with system page latch concurrency enhancements in SQL ...
Part of the SQL Server 2022 blog series. Over the past several SQL Server releases, Microsoft has improved […]