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. […]
View Event: Lifting your Data Skills to the Cloud 94% of enterprises use cloud services. 67% of enterprise infrastructure is now cloud-based. 92% of businesses have a multi-cloud strategy in place or in the works. What does that mean for data professionals working with on-premises technology for years? Do we have to relearn everything from […]
View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premises SQL Database to the cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on-demand, scaling up resources during high peaks, and scaling down when unused. You also want to ensure […]
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 […]
