October 18, 2021
View Event: Query store hints demo Query Store hints feature provides an easy-to-use method for shaping query plans without changing application code. This feature is a member of the Intelligent Query Processing family. In this demo-only session, I will show how to use and take advantage of Query Store hints.
October 4, 2021
View Event: What the heck is a checkpoint, and why should I care? An 8K page is the fundamental unit of data storage in SQL Server. For performance reasons, SQL Server performs every data modification operation in memory (buffer pool) and does not write it back to disk immediately. This is where checkpoint comes into […]
November 9, 2021
View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the Microsoft SQL Server Database Engine’s latest version. You can build data-driven applications and websites in the programming language of your choice without needing to manage infrastructure. While considering Azure SQL Database, two of the most critical […]