Row-Level Security in SQL Server
Explore Row-Level Security in SQL Server to control data access without altering application logic effectively.
Azure SQL
Azure Data Engineer
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
Row Versioning in SQL Server
Row versioning fundamentally changes how SQL Server handles read operations during write transactions. Instead of blocking, SQL Server can serve a previous version of the row. We enable row versioning in SQL Server by turning on READ_COMMITTED_SNAPSHOT ISOLATION (RCSI). In this post we will demonstrate blocking without row versioning and…
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.