A transaction log backup failed with Error: 3203, saying the read on the LDF file failed with Incorrect function. Here is what I found.
SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079
Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.
SQL Server – Knowing the Use of Deprecated or Discontinued Features
After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.
SQL SERVER – Generating Row Number Without Ordering Any Columns
ROW_NUMBER needs an ORDER BY clause, but what if you do not want to sort by any column? Here is a simple trick to generate a row number without ordering.
SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger
A reader’s database kept switching back to compatibility level 80 every day. Here is how a DDL trigger can catch who ALTERed the database and when.
SQL AZURE – How to Disable and Enable All Constraint for Table and Database
sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.
SQL SERVER – Recovering from Snapshots – Notes from the Field #078
Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.