Tag: Migration
-
DBA Scripts: Get Database Inventory
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration One Query, Every Database’s Migration Readiness Before you migrate, upgrade, or consolidate anything, you need one honest answer per database: is it actually online, what recovery model is it running, and is its compatibility level going to surprise you…
Written by
-
DBA Scripts: Generate Migration Scripts
This post has been split into a pillar and five focused posts, each generator script now has its own page with its own real bugs, Example Output, and Related Scripts, rather than five topics crammed into one long post. Start at the hub: SQL Server Migration Script Generators All five scripts, the repo links, and…
Written by
-
DBA Scripts: Get Linked Servers
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration Four Questions, One Topic: What’s Linked to This Server Linked servers are the kind of configuration that gets set up once, for one integration, and then forgotten until a migration or an incident forces someone to ask what’s actually…
Written by
-
DBA Scripts: Fix Orphaned Users
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Security From Finding Orphaned Users to Actually Fixing Them Get Orphaned Users answers “do I have this problem”. This script answers the next question: “what do I actually run to fix it”. After a database restore onto a server where the matching…
Written by
-
DBA Scripts: Get Edition Feature Usage
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration What Actually Breaks If You Downgrade This Instance Edition downgrades, Enterprise to Standard, Standard to Web, look simple until you discover a feature that only Enterprise supports has quietly been in use the whole time. TDE-encrypted databases won’t open…
Written by
-
DBA Scripts: SQL Server Migration Script Generators
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Moving a SQL Server workload to a new instance means recreating five things by hand, unless you script them: logins (with the same SIDs, or every restored database ends up with orphaned users), SQL Agent jobs, database user and role mappings, linked servers,…
Written by
-
DBA Scripts: Generate Restore With Move Script
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Migration & Deployment Generating RESTORE … WITH MOVE for a Migration With a Different Drive Layout Moving a SQL Server workload to a new instance where the target’s drive layout doesn’t match the source means every RESTORE DATABASE needs a WITH MOVE…
Written by
-
DBA Scripts: Generate Linked Server Script
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Migration & Deployment Recreating Linked Servers and Login Mappings for a Migration Moving a SQL Server workload to a new instance means recreating every linked server and its login mappings, unless you script it. This script produces sp_addlinkedserver and sp_addlinkedsrvlogin DDL for…
Written by
-
DBA Scripts: Generate User Mapping Script
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Migration & Deployment Recreating Database Users, Roles, and Role Memberships for a Migration Moving a SQL Server workload to a new instance means recreating every database user, custom role, and role membership, unless you script it. This script loops over every online,…
Written by
-
DBA Scripts: Generate Agent Job Script
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Migration & Deployment Recreating Every SQL Agent Job for a Migration, in the Right Order Moving a SQL Server workload to a new instance means recreating every SQL Agent job, unless you script it, and getting the order wrong (steps before the…
Written by
Start Here
- DBA Scripts: The Complete Guide
- Run a Full Health Check
- DBA Scripts & Tools
- SSMS: The Complete Guide
- Wait Types Library
The Pillars
Blog Categories
- Backups & Recovery (5)
- DBA Scripts (147)
- High Availability (HA) (7)
- Installation & Configuration (16)
- Maintenance (4)
- Migration & Upgrades (1)
- Monitoring (6)
- Performance Tuning (5)
- Security (Encryption & Permissions) (3)
- T-SQL Fundamentals (11)
- Troubleshooting (23)
- Wait Types (235)
Latest Posts
- Compatibility Levels: What Actually Changes When You Bump It
- SQL Server Management Studio (SSMS): The Complete Guide
- SQL Server Collation: Case Sensitivity and the Cross-Database Trap
- SQL Server Isolation Levels (and When to Reach for RCSI)
- DBA Scripts: Get Database Summary
- DBA Scripts: Get Database Inventory
Blog Tags
Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Jobs (3) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)