Bedrock Tech Talks

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, […]

Capital Area SQL Server User Group

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 […]

Default database for SQL Server login

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 […]

Come Cloud With Us

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 […]

Triangle SQL Server User Group

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 […]

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook