View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise SQL Database to cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in […]
View Event: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language! 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). As we make progress in our migration […]
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. having to use options and trace flags […]
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. having to use options and trace flags […]
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 […]
On May 26th @MarshaPierceDBA is showing us how to deploy SQL Server on containers. Should be a great session. It would... be great to see some #SQLFamily in attendance. Hope to virtually see you then! https://bit.ly/2Ks9zWg
