Power Tools for Visual Studio Team System 2008 Database Edition

Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition! Cool new stuff includes a couple new test conditions, file- and XML-based data generators, and (my favorite) SQL Static Code Analysis integrated into MSBuild / Team Build! Download page:http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en Installer download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi Documentation download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc Great work Team! …
Continue reading Power Tools for Visual Studio Team System 2008 Database Edition

Power Tools for Visual Studio Team System 2008 Database Edition

Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition! Cool new stuff includes a couple new test conditions, file- and XML-based data generators, and (my favorite) SQL Static Code Analysis integrated into MSBuild / Team Build! Download page:http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en Installer download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi Documentation download:http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc Great work Team! …
Continue reading Power Tools for Visual Studio Team System 2008 Database Edition

Introducing Change Data Capture, SSIS, and SQL Server 2008 CTP5 (Nov 2007)

Introduction  On Thursday, 24 Jan 2008, I presented New Features In SSIS 2008 to the Richmond SQL Server Users Group. Most of the presentation was dedicated to demonstrating Change Data Capture (CDC) interacting with SQL Server 2008 Integration Services. I started seriously working on this demo the first week of January, thinking I’d put 2 – 6 …
Continue reading Introducing Change Data Capture, SSIS, and SQL Server 2008 CTP5 (Nov 2007)

Database Testing on .Net Rocks!

I am honored to be the guest of a .Net Rocks! show on Database Testing! Richard Campbell, Carl Franklin, and I recorded the show last night and I had a lot of fun! Richard and I commiserated about the “DBA condition” in the enterprise. Everyone shared “war stories” about projects. A good time was had by all. I …
Continue reading Database Testing on .Net Rocks!

Speaking in Raleigh and Philadelphia This Week

Now that our 5-month old son – Riley Cooper – is on the mend, I am hitting the speaking trail again! 09 Jan 2008: I’m presenting Testing The Database to the Triangle .Net User Group (TRINUG) Wednesday evening in Research Triangle Park, NC (location details). 12 Jan 2008: I’m presenting Incremental Loads With SSIS – …
Continue reading Speaking in Raleigh and Philadelphia This Week

VSTS 2008 VPC Images

Microsoft released a couple Visual Studio 2008 Team System VPC images over the holidays – one loaded with Team System 2008, Team Explorer, and TFS 2008; the other with TFS 2008 and Team Explorer only. The images expire 1 Apr 2008 and provide a cool way to tinker with the new stuff without the hassles of …
Continue reading VSTS 2008 VPC Images

SSIS Design Pattern – ETL Instrumentation, Part 4

Introduction This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we expanded on our database and the SSIS package …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 4

SSIS Design Pattern – ETL Instrumentation, Part 4

Introduction This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we expanded on our database and the SSIS package …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 4