According to numerous sources – most recently a SQL Server Magazine article entitled Too Soon for SQL Server 2008? Readers Say “Yes!” – a lot of SQL Server customers are holding off upgrading to SQL Server 2005, preferring to wait for the upcoming release of SQL Server 2008. While I understand the economics, I worry about the DBAs …
Continue reading Skipping SQL Server 2005
Author:Andy Leonard
Visual Studio 2008 RTM
Visual Studio 2008 Team Suite bits are available for download to MSDN Subscribers! :{> Andy
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 on our database and the SSIS package …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 3
New Public SQL Server 2008 CTP (Almost) Available!
The new SQL Server 2008 (Katmai) CTP is now available for public consumption! :{> Andy Update: The bits are not yet public. My apologies. See comment #4 below. – Andy
SQL Server Intellisense is coming…
The next CTP of SQL Server 2008 promises to have Intellisense functionality! :{> Andy
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 own SSIS custom tasks and components. Free registration to CodePlex …
Continue reading SSIS Custom Tasks and Components Samples
Question Process
Steve Rowe has an excellent post on why we should revisit process and procedure from time to time. :{> Andy
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 expand on our database and the SSIS …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 2
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 expand on our database and the SSIS …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 2
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 expand on our database and the SSIS …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 2
