Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.
Keeping Your Own Script Library
A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.
Keeping Database Documentation Next to the Code
Keep database documentation close to SQL Server objects with extended properties, durable module comments, and catalog-generated reports.
SQL SERVER Cheatsheet – Released for SQL Server 2012 Edition
The SQL SERVER Cheatsheet is updated for SQL Server 2012, now with SSMS shortcuts, Columnstore Index, and the datetime, ranking and analytic functions.
SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0
Microsoft released AdventureWorks for SQL Server 2012 RC0. Here is the download link, plus why this sample database belongs on a development box only.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31
The complete downloadable list of my 31-day series of SQL Server interview questions and answers, with a free PDF for offline review at the end.