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: 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 […]
