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.
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 […]
View Event: Analyzing Azure Monitor Log data in Azure Data Studio How do you consume the data once you enable event logging (auditing and diagnostic) for the Azure SQL database? How do you find anomalies to alert on, establish a baseline, look at trends?In this 100% demo session, I will show you kql magic, kql […]
View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
View Event: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 232 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud. In this all demo session (Yes, no slides), I will show […]
