View Event: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 313 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 demo session (Yes, no slides), I will show you […]
View Event: What the heck is a checkpoint, and why should I care? An 8K page is the fundamental unit of data storage in SQL Server. SQL Server performs every data modification operation in memory (buffer pool) for performance reasons and does not immediately write it back to disk.This is where checkpoint comes into play. […]
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 progress in our migration to […]
View Event: The magnificent seven and beyond – Intelligent Query Processing in SQL Server Can we 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. using options and trace flags to gain performance. […]
View Event: The magnificent seven and beyond- Intelligent Query Processing in SQL Server Can we 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. using options and trace flags to gain performance. Adaptation […]
