SQL Server DBA, BI Analyst and Microsoft MVP

Categories

Azure SQL Database

9 posts

Azure SQL Database - DTU, vCore, General Purpose, Serverless, Business Critical, Hyperscale, Elastic Pool: Which to Choose?

January 2, 2026 27 min read

Continue reading

SQL Server - Change Tracking vs CDC: When and how to implement lightweight data tracking

December 31, 2025 15 min read

Continue reading

SQL Server 2025 - We finally have native regular expression (regex)

December 30, 2025 29 min read

Continue reading

Azure SQL Database Firewall - How to Configure Server-Level and Database-Level Rules

December 28, 2025 5 min read

Continue reading

Azure SQL Managed Instance - Warning! Why Shrink Can Destroy Your Performance

December 28, 2025 5 min read

Continue reading

Azure Data Factory (ADF) - How to Change the Service Objective and Resize an Azure SQL Database Using T-SQL Commands

August 13, 2022 5 min read

Continue reading

Azure SQL Database - How to Create and Manage Users and Logins with SQL and Azure Active Directory (Azure AD) Authentication

May 13, 2022 11 min read

Continue reading

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

April 14, 2022 7 min read

Continue reading

Azure SQL Database - How to view the automatic backup history

April 14, 2022 2 min read

Continue reading