October 10, 2021
View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, enabling rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk for a […]
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 […]
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 […]