Restoring a SQL Server 2016 backup on a 2014 instance fails with Error 3169, backed up on a server running a newer version. Here is why and what you can do.
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
Do you use the actual or the estimated execution plan? A candidate asked me this in an interview. I always use the actual plan, and here is why.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
Offloading Backups to a Secondary Replica: Notes from the Field #108
Offloading backups to a secondary replica takes work off the primary server. In Notes from the Field #108, Eduardo Castro explains backup priority and read-only routing for AlwaysOn availability groups.
SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1
Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.