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.
Backup Detected Log Corruption: Context Is Bad Middle Sector
Backup detected log corruption in a client’s database, and every full backup failed at exactly 60 percent. Instead of rebuilding the log, we checked the VLFs and found a log waiting on REPLICATION. Removing the leftover replication fixed the backup.
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.
Collecting Server Hardware Facts Before a Tuning Session
Capture server hardware facts from SQL Server views, keep an inventory, and distinguish visible resources from workload sizing evidence.
![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.