Tag: Migration

  • DBA Scripts: Get Linked Servers

    Part of the DBA-Tools Project. 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 connected to this instance and how. There are four separate questions…

    Written by

    Peter Whyte

  • DBA Scripts: Get Edition Feature Usage

    Part of the DBA-Tools Project. 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 on Standard at all. Resource Governor configuration silently stops working. A…

    Written by

    Peter Whyte

  • DBA Scripts: Get Migration Risk Assessment

    Part of the DBA-Tools Project. 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 SID that doesn’t exist anywhere anymore. Discovering these mid-cutover, instead…

    Written by

    Peter Whyte

  • DBA Scripts: Get Migration Login Audit and Post-Migration Validation

    Part of the DBA-Tools Project. Before the Migration: What to Script. After: Did It Actually Work. Version Upgrade Readiness and Migration Risk Assessment cover getting ready. This post covers the two bookends of the migration itself: what needs scripting before you start, and how do you confirm the target actually matches the source once you’re…

    Written by

    Peter Whyte

  • DBA Scripts: Get Version Upgrade Readiness

    Part of the DBA-Tools Project. 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 before a version upgrade? Three scripts, three angles on the…

    Written by

    Peter Whyte

  • DBA Scripts: Get Login and Job Inventory

    Part of the DBA-Tools Project. Two Plain Inventories Every Migration Plan Needs Permissions and Role Membership and SQL Agent and Jobs already cover the deep-dive on access and job health. These two scripts are the plain, focused inventory underneath both: Get-LoginInventory lists every server login by type and status, no permission detail, just what exists.…

    Written by

    Peter Whyte

Blog Categories

Latest Posts

Blog Tags

Access (3) Always On Availability Groups (4) Auditing (7) Backups (4) Blocking Locking (6) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (28) Disk Space (5) Error Log (2) Extended Events (7) Features (6) High Availability (6) Indexes (5) Instance (3) Inventory (6) Jobs (3) Migration (6) Monitoring (24) Performance (19) Performance Troubleshooting (9) PowerShell (4) Queries (3) Query Behaviour (5) Security (7) SQL Agent (3) SQL Scripts (21) 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 (9) SQL Server Versions (2) Storage and Capacity (9) T-SQL (9) Temp DB (3) Tracing (7) Transaction Logs (5) Troubleshooting (14) Windows Server (4)