December 20, 2023
View Event: Analysing 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, […]
November 22, 2023
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 and […]
October 24, 2023
Why do SQL Server Logins have a default database? Kenneth Fisher and Aaron Bertrand explain this here and here. Here is a sample script to identify logins whose default database no longer exists on the server. Once you identify, you can assign another database as default to avoid the issues explained in the abovementioned two […]
October 26, 2023
View Event: Considerations for migrating SQL databases to Azure Many tools are available to migrate your on-premises database to an Azure SQL database. Are you familiar with all those tools, and how do you choose the best tool? How do you analyze and identify what objects are incompatible with migrating to Azure? Answer: It depends […]
October 17, 2023
View Event: Analyzing Azure Monitor Log data for Azure Resources Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). We learn new ways to monitor and alert resources and […]