MPP Architecture in Synapse SQL Pools
Explore MPP Architecture in Synapse SQL Pools to optimize data processing and enhance query performance across large datasets.
Azure SQL
Accelerated Database Recovery in SQL Server
Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions. What Is Database Recovery? In a previous post, I discussed the SQL Server Restore and Recovery…
Azure Data Engineer
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
Creating Indexes that Cover a Query
Explore the importance of indexes that cover a query and how they can improve SQL Server performance and eliminate lookups.
Restore and Recovery
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
Azure and M365 Fundamentals
Finally picked up my Azure Fundamentals Certifications. I have been slacking a little on the certification exams. I have been a bit busy the last couple of months. I have plans to add many of the new role-based certifications to my list once the Microsoft courseware comes out. But in…
Table Constraints
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
Tables and Relationships
Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.
Conversational Microsoft Azure
Explore Conversational Microsoft Azure and learn how its cloud services can benefit organizations of any size.