Category:Uncategorized

The recording of the presentation Using Enterprise Data Integration Dashboards is now available! Enjoy! :{>

Logging – Level 11 of the Stairway to Integration Services is now available on the SQL Server Central Stairway to SSIS page! Enjoy! :{>

Advanced Event Behavior – Level 10 of the Stairway to Integration Services is now available on the SQL Server Central Stairway to SSIS page! Enjoy! :{>

Join Kent Bradshaw and I as we present Using Enterprise Data Integration Dashboards Tuesday 11 Dec 2012 at 10:00 AM ET! If data is the life of the modern organization, data integration is the heart of an enterprise. Data circulation is vital. Data integration dashboards provide enterprise ETL (Extract, Transform, and Load) teams near-real-time status …
Continue reading Free Webinar – Using Enterprise Data Integration Dashboards

Join Darryll Petrancuri and I as we present Loading Data Warehouse Partitions with SSIS 2012 Saturday 8 Dec 2012 at SQL Saturday 173 in DC! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Darryll Petrancuri and Andy Leonard demonstrate one approach to loading partitioned …
Continue reading Presenting Loading Data Warehouse Partitions with SSIS 2012 at SQL Saturday DC!

I am honored to present SQL Server 2012 Design Patterns at the University of Virginia’s Local Support Partners Fall Conference 2012 tomorrow! :{>

… unless there is a public apology. The day began with disappointment as PASS bloggers were warned to remain silent or “there won’t be a bloggers table next year.” This was in response to last year’s tweets and posts from the bloggers table that PASS and their sponsors found disagreeable. I disagreed with some of …
Continue reading A PASS Summit Blogger No More?

31 Oct 2012 Update 2: Microsoft made Team Foundation Service (formerly TFSPreview) public today!  – Andy 31 Oct 2012 Update 1: SQL Source Control 3.1 is available! – Andy 12 Oct 2012 Update: The SQL Source Control 3.1 update is currently unavailable. I will provide additional updates when this version is re-released. – Andy I …
Continue reading [Updated Again!] RedGate SQL Source Control and Team Foundation Service

In Want to Learn SQL Server 2012? I wrote about obtaining a fully-featured version of SQL Server 2012 (Developer Edition). This post represents one way to install SQL Server 2012 Developer Edition on a Hyper-V virtual machine running the Windows 2012 Server Standard Edition operating system. This is by no means exhaustive. My goal in …
Continue reading Installing SQL Server 2012 on Windows 2012 Server

Introduction This post is the fifty-sixth part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page. Over a career that spans decades, one encounters useful and “less useful” soft skills in the modern enterprise. I thought I would share a few of the less …
Continue reading Less Useful Soft Skills