Plan moving to Azure SQL Database by finding Agent jobs, cross-database references, CLR, FILESTREAM, linked servers, and recovery changes.
SQL SERVER – Generate In-Memory OLTP Migration Checklists – SSMS
One of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their database for In-Memory OLTP Migration.
Finding Edition-Bound Features With sys.dm_db_persisted_sku_features
Use sys.dm_db_persisted_sku_features before an edition move, inventory databases, and distinguish feature evidence from licensing checks.
SQL SERVER – Generating In-Memory OLTP Migration CheckList
A client asked me to check their In-Memory OLTP readiness and build a migration list. Here is how to generate the In-Memory OLTP Migration CheckList.
Oracle to SQL SERVER Migration – Triggers Used While Migration
Moving from Oracle to SQL Server is like switching phones: old habits come along. A client tuning case about the triggers used during the migration.
Extended Security Updates Explained
Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.
Migrating From PostgreSQL to SQL Server: Types and Syntax Differences
Plan migrating from PostgreSQL by checking identity values, Unicode, timestamps, paging, returned rows, collations, and upsert behavior.