View Event: Azure SQL DB Backups – Isn’t Microsoft taking care of that? Most people think you no longer have to care about backups once you move to the cloud. You still need to confirm that you do not violate your company policy and regulatory requirements because of the default values. In this session, we […]
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: What the heck is a checkpoint, and why should I care? In SQL Server, a checkpoint is an internal process that writes dirty pages and transaction log records from memory to disk and marks a point in the transaction log. An 8K page is the fundamental data storage unit in SQL Server. SQL […]
