Azure SQL Monitoring Tools and Automation
Discover the benefits of Azure SQL monitoring tools and automation to streamline your database performance and configuration checks.
MCT
SQL Server Management Studio (SSMS) 21 Preview 2
SQL Server Management Studio (SSMS) 21 Preview 2 released Highlights SSMS 21 Preview 2 was released yesterday, December 10th! Preview 2 can be downloaded from https://aka.ms/ssms/21/preview/vs_ssms.exe What’s in Preview 2 Added support for multi-tenant scenario in authentication control Completed dark theme support for SQL results tabs and results grid header Initial…
Announcing Microsoft SQL Server 2025 and SSMS 21.
Announcing Microsoft SQL Server 2025 and SSMS 21. Microsoft SQL Server 2025, now in preview, is an enterprise AI-ready database from ground to cloud that tackles these challenges by bringing AI to customers’ data. This release continues SQL Server’s three decades of innovation in performance and security, adding new AI capabilities….
SQL Skills Blackbelt on SQL Server 2019
Extremely rewarding to be only the 46th person to earn this demanding badge from SQL Skills. It is only achieved after attending SEVEN deeply technical courses focused on Microsoft SQL Server. In total, these courses provide over 155 hours of content and demonstrations.
MPP Architecture in Synapse SQL Pools
The purpose of Massively Parallel Processing (MPP) is to scale out compute nodes and reduce workload per compute node to query large volumes of data. Control Node There will always be 1 Control Node that is used to connect to and manage the SQL Pool. The data in a table…
SQL Server Technical Reviewer
After several attempts, I finally got to see my name in an actual published book. Not as an author but a technical reviewer of the SQL Server 2022 Performance Tuning book written by Grant Fritchey. I have been reading every version of this book since at least the second edition…
Customer Facing Skills Initiative
The Customer Facing Skills Initiative (CFSI) is a series of four soft skills courses for Microsoft employees to help them excel in their role
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
Microsoft Azure Certification Summer
During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.
The SQL Server Database Engine
The three parts of the SQL Server database engine with a focus on how the SQL Server Operating System (SQLOS) component manages resources.