Administration

Azure Migration

Accelerating SQL Server Migration

Migrating SQL Server databases to the cloud has traditionally been a complex, time-consuming process. But with Microsoft’s new unified migration experience for SQL Server enabled by Azure Arc—now in public preview—the journey to Azure SQL Managed Instance is faster and simpler than ever.

SQL Server 2016 End of Support

Modernize and Secure Your SQL Server 2016 Workloads

Microsoft has just announced new guidance and tools to help organizations protect and modernize their SQL Server 2016 workloads as the product approaches its End of Support (EOS) on July 14, 2026. What does End of Support mean? Microsoft Lifecycle Policy offers 10 years of support (five years for mainstream…

Migration Dashboard for SQL Server Enabled by Azure Arc

Migration Dashboard for SQL Server

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 in SQL Server 2019

Accelerated Database Recovery in SQL Server

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…