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.
SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor
The SSIS Balanced Data Distributor (BDD) spreads incoming rows across outputs with multithreading. How it works and the scenarios where it improves performance.
Keeping a Change Log for Every Database
A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.
Documenting a Server You Just Inherited
Documenting a server you just inherited starts with identity, databases, files, jobs, access, alerts, and tested recovery ownership.
SQL SERVER – What is AdventureWorks?
What is AdventureWorks? Why I use this SQL Server sample database in my examples, how it replaced Northwind and Pubs, and where to get it.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.






