Monthly Archives: November 2007

SSIS Performance Tuning Strategy

Similar to my post on SSIS Performance Tuning Techniques, this resource is neither mine nor new, but it looks like a lot of people don’t know that it exists. Check out this “SQL Server 2005 Integration Services: A Strategy for … Continue reading

Posted in BI, Performance, SQL Server, SSIS | Leave a comment

Calling All Trainers!

If you’re a Microsoft Certified Trainer, this is a very exciting time. With new versions of SQL Server, Visual Studio and Windows Server right around the corner (or in the case of Visual Studio 2008, upon us already) you are … Continue reading

Posted in BI, Conference, Katmai, SQL Server, Training | Leave a comment

Speaking at SQL Connections 2008

I just received news that my abstract for the session “SQL Server Integration Services Deployment Best Practices” was selected for the spring 2008 SQL Connections conference. As you can imagine, I’m awfully excited! Here’s the full abstract: “So you’ve built … Continue reading

Posted in BI, Conference, SQL Server, SSIS, Training | 1 Comment

Let Your Voice Be Heard!

The SQL Server Integration Services Team is looking for your feedback on how to prioritize their work on future versions of SSIS. How cool is that? It’s not quite as cool as being invited to an SDR (yeah, this is … Continue reading

Posted in BI, SQL Server, SSIS | 2 Comments

SQL Down Under Show Online

Remember back on Halloween when I recorded an episode of SQL Down Under with SQL Server MVP Greg Low? Well, the episode is now online! You can download it in MP3 or WMA format here: Enjoy!

Posted in Best Practices, SQL Server, SSIS, Webcasts | Leave a comment

Things are Looking Up in CTP5

One of the things I’ve really been looking forward to with SSIS in SQL Server 2008 CTP5 is the enhanced Lookup transform. And related to that was looking forward to blogging about it. But of course, I’m a day late … Continue reading

Posted in BI, Katmai, SQL Server, SSIS | Leave a comment

Katmai CTP5 – Public Download Available!

Microsoft has just posted the SQL Server 2008 CTP5 downloads to the public Download Center: Please note that there are both installers and ISOs for x86, x64 and IA64 as well as an Express Edition download. Very cool stuff … Continue reading

Posted in Katmai, SQL Server | Leave a comment

Line Numbers, Where Art Thou?

So as mentioned in my last post, I’m delighted to be able to use C# in the Script Task and Script Component in SSIS for Katmai CTP5. I was a bit less that delighted, however, to not have any line … Continue reading

Posted in dev, Katmai, SQL Server, SSIS | 3 Comments

Katmai Scripting: A Step in the Right Direction

In a recent thread on the SSIS forums on MSDN, a poster was bemoaning the number of steps required to open the VSA script editor for the Script Task in SSIS. And I was sharing his pain. Fortunately, there is … Continue reading

Posted in BI, Katmai, SQL Server, SSIS | Leave a comment

BIDS Helper 1.2 Released

BIDS Helper is a CodePlex project that delivers a set of Visual Studio add-ins for developers working on BI projects. It’s been around for a while, but until now has not had any SSIS-focused features. Until now! The BIDS Helper … Continue reading

Posted in BI, dev, SQL Server, SSIS, tools | 2 Comments