Tag: database migration

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

9 Mar 2026 · 6 min read

SQL Server Migration Assessment: A Complete Guide

A SQL Server migration assessment tells you what will break, what's compatible and what infrastructure you need. Here's how DBA Services runs them properly.

Read article →
1 Sep 2025 · 6 min read

When You Need a SQL Server Migration (Not Just Another Upgrade Script)

A SQL Server migration is far more than running an upgrade script. Learn the ten scenarios where migration is genuinely necessary and how to do it without creating new problems.

Read article →
15 May 2018 · 6 min read

How to Fix Orphaned Users on an SQL Server

Orphaned users are one of the most common issues after SQL Server migrations and restores. Learn how to identify and fix them before they break production access.

Read article →
15 May 2018 · 6 min read

Be Mindful of Deprecated Features in SQL Servers

Relying on deprecated SQL Server features is one of the fastest ways to turn a planned migration into an emergency. Learn how to audit and address them before you upgrade.

Read article →
15 May 2018 · 2 min read

Transfer / Migrate users between versions of SQL Server

Migrating SQL Server logins requires more than moving databases. Learn how to transfer logins with original SIDs and password hashes intact using sp_help_revlogin.

Read article →
15 May 2018 · 7 min read

SQL Server Migration Checklist

A comprehensive SQL Server migration checklist to ensure nothing gets left behind, from data files and logins to agent jobs and linked servers.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.