Introducing Database Watcher for Azure SQL
Introducing Database Watcher for Azure SQL, the ultimate monitoring tool for enhancing your Azure SQL database observability.
Azure SQL
SQL Server and Azure SQL Updates
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…
MPP Architecture in Synapse SQL Pools
Explore MPP Architecture in Synapse SQL Pools to optimize data processing and enhance query performance across large datasets.
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.
Writing SARGable Expressions in T‑SQL
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.
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?