General Availability of SSMS 22
SQL Server Management Studio (SSMS) 22 is now generally available! Discover powerful features and enhancements today.
SQL
Meet the NEW Azure SQL Hub
If you’ve ever felt lost trying to figure out Azure SQL, you’re not alone. Microsoft just dropped something pretty cool, the ALL NEW Azure SQL Hub and it’s here to make your cloud database journey much easier. What’s Azure SQL Hub? Think of Azure SQL Hub as your one-stop shop…
SQL Security with Microsoft’s Zero Trust Workshop
Explore SQL Security with Microsoft’s Zero Trust Workshop to enhance your organization’s defense against threats.
SQL Server 2016 Migration Guidelines
Get ready for your SQL Server upgrade! Follow these SQL Server 2016 migration guidelines to ensure a smooth transition.
SSMS 21 – Preview 3 Updates
I wanted to share some updates from the SQL Server Management Studio (SSMS) team, as highlighted in recent blog posts. These updates bring new capabilities to SSMS, which I believe will be beneficial for ongoing and future projects. SSMS 21 Preview 3 release: The latest preview of SSMS 21 introduces…
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…
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
Troubleshooting Waiting Tasks
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
SQL Query Processing
How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.