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…
Explore SQL Security with Microsoft’s Zero Trust Workshop to enhance your organization’s defense against threats.
Get ready for your SQL Server upgrade! Follow these SQL Server 2016 migration guidelines to ensure a smooth transition.
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…
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.
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…
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?