Upcoming changes for SQL Server Management Studio (SSMS). This is the first of three blog posts about the next releases of SQL Server Management Studio (SSMS), and the roadmap for 2024! Learn more: SSMS 20 connection changes (microsoft.com) Get started planning SQL Server 2014 end of support. Did you know that…
Achieve the SQL Skills Blackbelt by completing seven technical courses on Microsoft SQL Server and Azure SQL Databases.
Explore MPP Architecture in Synapse SQL Pools to optimize data processing and enhance query performance across large datasets.
Explore the insights from the SQL Server 2022 Performance Tuning book, featuring expert reviews and detailed analysis.
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
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 Task Execution Model used in the Database Engine for efficient CPU thread scheduling and task management.
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.