AndyLeonard.blog()

You have to wonder if the Visual Studio Team System teams ever sleep… In the same month they released Visual Studio 2008 to manufacturing, the VSTS team has a fresh CTP VPC available for the next version! Download the bits here. :{> Andy

Harper Trow of GenYSystems tells me he cannot open SSIS 2005 packages in Visual Studio 2008. I have not yet confirmed this personally but I trust Harper implicitly – he’s one of the smartest developers I know. More later… In a related story: there’s a download that allows you to interact with SQL Server 2008 CTP …
Continue reading SSIS and Visual Studio 2008

Gert D announced Visual Studio 2008 Team System Database Edition on his blog today. There’s more good information on Gert’s blog about Database Edition, including plans to release a 2008 version of Power Tools “later this month”! :{> Andy Technorati Tags: Database Edition Power Tools, Visual Studio 2008

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

  Visual Studio 2008 Team Suite bits are available for download to MSDN Subscribers! :{> 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 …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 3

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

The next CTP of SQL Server 2008 promises to have Intellisense functionality!  :{> Andy

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

Steve Rowe has an excellent post on why we should revisit process and procedure from time to time. :{> Andy