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 services […]
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: Break five common myths about SQL Server backup In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer. 1. Does Full and Differential backup breaks the log chain?2. Are Differential backups incremental?3. What backups are allowed on system databases?4 Is transactional […]
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. […]