November 10, 2021
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 […]
November 2, 2021
Definition Data warehouse snapshot A data warehouse snapshot creates a restore point you can leverage to recover or copy your data warehouse to a previous state. Since a dedicated SQL pool is a distributed system, a data warehouse snapshot consists of many files that are located in Azure storage. Snapshots capture incremental changes from the data stored […]
October 26, 2021
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 […]
October 30, 2021
View Event: The magnificent seven – Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. using options and trace flags to gain […]
October 14, 2021
View Event: The magnificent seven – Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. using options and trace flags to gain […]