It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database used to be installed as part of the SQL Server installation process. Fast forward to ...

GitHub is where people build software. More than 225 million people use GitHub to discover, fork, and contribute to over 800 million projects.

Microsoft SQL Server Integration Services (SSIS) is an enterprise platform for setting up data integrations and data transformations. The main elements of the SSIS architecture are two engines. These ...

Relational SQL databases, which have been around since the 1980s, historically ran on mainframes or single servers—that’s all we had. If you wanted the database to handle more data and run faster, you ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...