Welcome to VSTSC's Community Server Sign in | Join | Help

Browse by Tags

Saturday, September 13, 2008 5:05 PM

My 2008 PASS Sumit Presentations

I am honored to be selected to present at the 2008 PASS Summit ! I'm presenting two sessions: Test-Driven Development For Database Professionals and SSIS Scripting . I've been working on the presentations recently and realize there will be a few minutes
Posted by andy | 1 Comments
Wednesday, August 27, 2008 4:06 AM

SSIS Design Pattern - Collect Enterprise SQL Server Database Metadata With SSIS

Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email.
Posted by andy | 0 Comments
Thursday, August 21, 2008 7:23 PM

New SSIS 101 Article!

My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy
Posted by andy | 0 Comments
Filed under:
Tuesday, July 15, 2008 11:41 AM

Installing Visual Studio 2008 SP1 Beta

Introduction Visual Studio 2008 Service Pack 1 Beta is available. Installation is not straightforward - there is at least one "gotcha." Full SP documentation can be found here . Procedure Download Visual Studio 2008 Service Pack 1 Beta . I am installing
Posted by andy | 0 Comments
Monday, July 14, 2008 4:29 PM

Installing SQL Server RC0

Introduction SQL Server 2008 RC0 has been out for a while. You can download it here . This post is not a detailed examination of the setup options. There are much better articles and posts out there if you want more information. This post represents one
Posted by andy | 1 Comments
Tuesday, April 01, 2008 7:53 PM

MVP Renewed!

I received the news today: Microsoft has awarded me SQL Server MVP again this year. How cool! Thanks Microsoft! :{> Andy
Posted by andy | 0 Comments
Filed under:
Friday, February 15, 2008 5:08 AM

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
Posted by andy | 0 Comments
Saturday, February 09, 2008 12:01 AM

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.
Posted by andy | 0 Comments
Wednesday, December 19, 2007 11:59 PM

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
Posted by andy | 0 Comments
Sunday, December 09, 2007 12:12 AM

Installing Virtual Server On Vista Ultimate 64-bit

Mea... This may be a little off-topic. I use Virtual Server and Virtual PC a lot for things like testing beta and CTP releases of SQL Server. I don't have time or the inclination to reformat physical hard drives, load an OS, or even fiddle with restoring
Posted by andy | 1 Comments
Filed under: , ,
Sunday, November 18, 2007 4:13 PM

SSIS Design Pattern - ETL Instrumentation, Part 3

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
Posted by andy | 1 Comments
Tuesday, November 13, 2007 11:14 AM

SSIS Custom Tasks and Components Samples

You can find SSIS 2005 Custom Tasks and Component Samples at CodePlex . At the same location you can find SSIS 2008 samples. How cool is that? The samples include source code in VB.Net and C#. They serve as a decent starting place for developing your
Posted by andy | 0 Comments
Saturday, November 10, 2007 7:41 AM

SSIS Design Pattern - ETL Instrumentation, Part 2

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 will
Posted by andy | 5 Comments
Sunday, October 14, 2007 6:28 AM

SSIS Design Pattern - Read a DataSet From Variable In a Script Task

Introduction One of the things I appreciate about SSIS is the script elements. There is a lot of functionality built into the engine out of the box but I like the idea of having a Script Task on the Control Flow and a Script Component on the Data Flow
Posted by andy | 0 Comments
Filed under: , ,
Wednesday, September 05, 2007 2:17 PM

Sample chapters from the new Testing With VSTS book!

There's a couple same chapters available for a new book I co-authored: Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers Chapter 1: Introduction to VSTEST / VSTESD is available from the
Posted by andy | 0 Comments
More Posts Next page »