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: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 244 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 […]
