Author: Peter Whyte
-
DBA Scripts: SQL Server Change Management
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Change window open and you need the checklist or the rollback criteria now? Start Here goes straight to them. The rest is the paperwork either side of the window: how a change gets approved, proved safe before you start and…
Written by
-
Windows Server OS Upgrade Runbook for SQL Server
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Upgrading the operating system underneath SQL Server is usually driven by someone else: a support deadline, a security policy, a hardware refresh. That does not make it someone else problem, because SQL Server is the thing that will be blamed…
Written by
-
SQL Server Edition Change Runbook: Upgrade and Downgrade
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Changing SQL Server edition is two completely different jobs depending on which way you are going. Upgrading is a setup.exe operation measured in minutes. Downgrading is a migration, because there is no supported in-place path, and it starts with an…
Written by
-
SQL Server Version Upgrade Runbook: Side-by-Side and In-Place
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment There are two ways to upgrade a SQL Server version, and the choice is really a choice about what your rollback looks like. Side-by-side gives you a rollback that consists of pointing the application back at a server which is…
Written by
-
SQL Server Migration Runbook: Availability Groups and Failover Clusters
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Migrating a highly available instance is not one job, it is two different jobs that people frequently confuse. An Availability Group migration adds replicas and fails over. A Failover Cluster Instance migration builds a new cluster and cuts over. The…
Written by
-
SQL Server Migration Runbook: Standalone Instance
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Moving a standalone SQL Server instance to new hardware is the most common migration there is, and the one most often done from memory. The databases are the easy part. What catches people is everything around them: logins that arrive…
Written by
-
The Filegroup Cannot Be Removed Because It Is Not Empty (Error 5042)
SQL Server error 5042 means something still lives on the filegroup, often an index rather than the table you were thinking of. How to find it, move it, empty the files and remove it in the right order.
Written by
-
Kerberos vs NTLM in SQL Server: Best Practices
There are 2 ways in: a linked server failing as NT AUTHORITY\ANONYMOUS LOGON, and the discovery that an estate everyone assumed was on Kerberos is running on NTLM. Both are the same question, and one query answers it. ⚡Run one query: auth_scheme in sys.dm_exec_connections says KERBEROS or NTLM per connection. NTLM is not an error…
Written by
-
The SELECT Permission Was Denied on the Object (Error 229)
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them.In: Security Msg 229 · Level 14 · State 5 The SELECT permission was denied on the object ‘RlsOrders’, database ‘DemoDatabase’, schema ‘dbo’. Msg 229, Level 14, State 5 ⚡The message already names object, schema and database. Look for a DENY…
Written by
-
The Filegroup Has No Files Assigned to It (Error 622)
SQL Server error 622 arrives long after the mistake: creating a table on an empty filegroup succeeds, and the first insert is what fails. Why it is late, and the one statement that fixes it.
Written by
- DBA Scripts: Get Log Shipping Status
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
- How to Move TempDB Files in SQL Server
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (94)
- Wait Types (235)