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 […]
November 2, 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 19, 2021
View Event: Options and considerations for migrating SQL Server databases to Azure Many tools are available to successfully migrate your on-premises relational database to the Microsoft Azure SQL database. Do you know what tools are available for migration? How do you choose the best tool for you? How do you analyze and identify what objects […]