Happy Pi Day Everyone!  ... at least in the US datetime format... :{> Andy

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 to annotate version metadata, manage error metrics ...

The SQL Server PSS group announces the release of RML Utilities.  From the blog post:  The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft ...

Introduction: The World Series (1979) and Photography Willie ''Pops'' Stargell started my interest in photography (...a funny way to start a post on a SQL Server blog site, but bear with me). Pops Stargell led the 1979 Pittsburgh Pirates to win the World Series. He was the MVP that year as well. My Mom, in the only time I ever remember her ...

Introduction      There's quite a bit of hoopla about MDM lately, mostly due to awareness. While ''Lacks needed data'' was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), ''Insufficient or inadequate master data'' made a decent showing ...

The tune to a Bush song is running through my head as I type this... the band, not the president - although imagining the President singing the song is an interesting brain-stretch. It's a fact of IT life that everything scales. Some successfully, even. Problems start when things do not scale successfully (or well). It happens in business. It ...