Overview: Microsoft has announced the Migration Dashboard feature in the Azure portal, specifically for SQL Server instances enabled by Azure Arc. This dashboard provides a comprehensive view of your migration readiness and assessment coverage across all SQL Server instances. Key Features: Assessment Visibility: The dashboard automatically generates assessments for migration to Azure,…
Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions. What Is Database Recovery? In a previous post, I discussed the SQL Server Restore and Recovery…
Explore Row-Level Security in SQL Server to control data access without altering application logic effectively.
Learn about Data Pages in SQL Server, their structure, and how extents impact data storage efficiency within your database.
Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.