Business continuity is a foundational requirement for database platforms. Azure SQL provides multiple layers of resiliency that protects your data, maintains availability, and enables recovery from both localized failures and large-scale regional outages. (Download Presentation from Data Saturday Chicago) Let’s break down how the concepts of Business Continuity and Disaster Recovery (BCDR) works in Azure SQ. We…
Achieve the SQL Skills Blackbelt by completing seven technical courses on Microsoft SQL Server and Azure SQL Databases.
Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis.
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
Understand SQL Query Processing and how SQL Server parses and binds queries, ensuring syntax accuracy and resolving object names.
During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.
Explore the SQL Server Database Engine and its key components: SQLOS, Relational Engine, and Storage Engine.
Explore my journey through a summer of changes, moving from New Horizons to Microsoft and embracing new challenges.
In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…