Azure SQL Server DBA

Migration: Discovery, Assessment & Planning

Question

An estate inventory lists SQL Agent jobs, linked servers, and server-level triggers. Which target should planning favor?

Answer

Favor Azure SQL Managed Instance. Inventory each dependency and its security context, then validate feature support and migration treatment. Azure SQL Database removes dependencies on instance-scoped components, so redesign or externalize them before selecting it.

This is 12 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples