Replace six MySQL habits with SQL Server equivalents for LIMIT, AUTO_INCREMENT, quoting, GROUP BY, duplicate inserts, and collations.
Moving SSRS Reports to a New Server
Moving SSRS reports to a new server requires the ReportServer databases, encryption key, data source checks, and subscription rehearsal.
Azure SQL Database or Managed Instance
Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
Comparing Two Copies of a Table With CHECKSUM_AGG and HASHBYTES
Use CHECKSUM_AGG for a quick table-copy signal, then compare canonical HASHBYTES values and key ranges to locate real data differences.
BACPAC or Backup: When an Export Is the Wrong Tool
A BACPAC export has rows in it, but it is not a recovery backup. Here is a small demo that shows the difference.