The evolution of the DBA, as discussed in April 2018, through NoSQL, cloud services and better tools.
SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction
A failed SQL Server 2014 SP2 left the service down with: ALTER DATABASE statement not allowed within Multi-statement Transaction. Here is how to fix it.
SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed
One database would not seed to the secondary replica. Here is how sys.dm_hadr_physical_seeding_stats showed failure_code 15 and VDI Client Failed.
Delete Old Backup Files in SQL Express with PowerShell
SQL Server Express has no SQL Server Agent, so nothing runs to delete old backup files and the disk slowly fills. This post gives a PowerShell script that removes backup files older than a set number of days, tests it with a dry run, refuses to delete when any backup type has no recent file, and shows how to schedule it with Task Scheduler.
SQL SERVER – FIX: Backup Detected Log Corruption in database MyDB. Context is Bad Middle Sector
A client’s full backup always failed at 60%: backup detected log corruption, context is bad middle sector. Here is what the ERRORLOG showed and how we fixed it.
SQL SERVER – Mirroring Error 1456 – The ALTER DATABASE Command Could not be Sent to the Remote Server Instance
Adding a new witness server after a disaster failed with database mirroring error 1456. Here is one possible cause and what to check.
Renaming a Table With Almost No Downtime Using sp_rename
A rename swaps names in a blink, yet the foreign key and permissions stay with the old table. Here is a short demo and a safer swap.