Plan moving to Azure SQL Database by finding Agent jobs, cross-database references, CLR, FILESTREAM, linked servers, and recovery changes.
In-Memory OLTP Migration Checklist: Which Features Block You
An In-Memory OLTP migration checklist from SSMS lists the tables and procedures the engine will refuse. This post tests those refusals on SQL Server 2025, shows which old limits are gone, and adds a query that finds blockers in your own database.
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.