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. For performance reasons, SQL Server performs every data modification operation in memory (buffer pool) and does not write it back to disk immediately. This is where checkpoint comes into […]
View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the Microsoft SQL Server Database Engine’s latest version. You can build data-driven applications and websites in the programming language of your choice without needing to manage infrastructure. While considering Azure SQL Database, two of the most critical […]
View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the Microsoft SQL Server Database Engine’s latest version. You can build data-driven applications and websites in the programming language of your choice without needing to manage infrastructure. While considering Azure SQL Database, two of the most critical […]
View Event: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 232 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 all demo session (Yes, no slides), I will show […]
