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.
How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167
How to estimate space saved by data compression in SQL Server? Use the built-in sp_estimate_data_compression_savings procedure. Here is a quick example.
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.
![MySQL - Connection Error - [MySQL][ODBC 5.3(w) Driver]Host 'IP' is Not Allowed to Connect to this MySQL Server](https://blog.sqlauthority.com/wp-content/uploads/2018/03/mysql-login-err-04.jpg)
MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server
Setting up a linked server to MySQL, the ODBC test failed: Host ‘IP’ is not allowed to connect to this MySQL server. Here is how I fixed it.
SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
A client used AlwaysOn automatic seeding for a huge database, but it stayed in Restoring state on the secondary. Here is the reason we found.
SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification
Preparing a demo, I hit Msg 3231: media formatted for 1 media family, but 2 Media Families are expected. Here is what causes it and how to fix it.