Slides and demos for my hdc08omaha talks are now available for download from http://tinyurl.com/5oykgj Thanks to all who attended!

First up, my article Hierarchy ID has been published in MSDN Magazine. Its also available on the MSDN Web Site at http://msdn.microsoft.com/en-us/magazine/cc794278.aspx. Second, my recent interview with Dr. Greg Low and his world famous ''SQL Downunder Podcast'' is now avaialbe at http://www.sqldownunder.com/PreviousShows/tabid/98/Default.aspx. ...

A few days ago via Twitter (http://www.twitter.com/, follow me as ktegels), Mr. Lowe (AKA Vendoran) asked ''SQL Express with Advanced services comes with SSRS, but does it come with the ability to create/edit rdl in VS?'' The short answer to that question is ''it depends.'' In most of the pay-for-license editions of Visual Studio you can use the ...

Lookup. For many SQL Server Integration Services Developers, it's the transformation we most love to dislike - especially if you are using it against data living on remote server not on the same local network as the host running your package. This combination of circumstances sometimes drives us to some very inventive things. In this post I want ...

You have to give credit where credit is due, and I certainly have to give credit to Kirk Haselden et al and their book Microsoft SQL Server 2005 Integration Services. That book -- and some of trial and error -- taught me a lot about how to tune data flow tasks for better performance. The folks at Simple Talk have part of the book online ...

The RTM version of SQL Server 2008 and recently release of the CLR updates with Visual Studio 2008 SP1 gave us the SqlGeometryBuilder and SqlGeographyBuilder classes to work with. These are very handy, simple APIs but, well, lets just say that the documentation on them is a bit lacking (Isaac Kunen's as some discussion of them at Our Upcoming ...

I am going to get myself in trouble (again) by saying this but SSIS isn’t a Business Intelligence tool as much as it is a developer tool. If you are like me, you have written a lot of code does, basically, the following: Extracts the data from some place; Transforms that data somehow; Loads the transformed data into database or some other ...

I guess when the developers decide it is not. Consider the following query: drop table dbo.shapeParts go create table dbo.shapeParts( shapePartID tinyint not null identity(1,1) primary key, shapeID tinyint not null, shapeQuad tinyint null, shape geometry not null); go insert into dbo.shapeParts ...

On 6 August 2008, I will be giving a presentation to the Omaha SQL/BI User Group on the new features in SQL Server 2008 Integration Services. We will talk about improvements in scripting, how the redesigned pipeline improves performance and how to leverage the new Cache Transform to improve package performance. Quinn Jones from Farm Credit ...

I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Katmai / SQL Server 2008 cycle.  They have been on both 32 and 64-bit; with / ...