Tag: Migration
-
DBA Scripts: Get Migration Risk Assessment
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Every migration has a list of things that will cause a problem if nobody checks for them first: a database in an Availability Group that needs coordinated removal, a linked server dependency that won’t resolve on the target, an owner…
Written by
-
DBA Scripts: Get Migration Login Audit and Post-Migration Validation
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment You are about to move logins to a new server, or you just did and something cannot log in. These 2 scripts cover both ends: Get-MigrationLoginAudit tells you what each login needs on the target, and Get-PostMigrationValidation gives you 13…
Written by
-
DBA Scripts: Get Version Upgrade Readiness
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Before You Upgrade: What’s Actually Going to Break Migration Risk Assessment covers per-database risk findings when moving to different hardware or infrastructure. This post covers a narrower, earlier question: on THIS server, staying on the same infrastructure, what needs attention…
Written by
-
DBA Scripts: Get Login and Job Inventory
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security Two Plain Inventories Every Migration Plan Needs Permissions and Role Membership and SQL Agent and Jobs cover the deep dive. These two are the plain inventory underneath both: Get-LoginInventory: the logins a migration has to recreate, by type and status. No permission…
Written by
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- The Current Transaction Cannot Be Committed (Error 3930)
- Sort and Hash Spills to TempDB: Find the Query and Fix the Grant
- Backups & Recovery (17)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (23)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)