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
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.
Transactions and Errors
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?
Restore and Recovery
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.