March 17, 2023
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. […]
March 18, 2023
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 […]
March 21, 2023
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 […]