Browse by Tags

• cache
• cache transform
• GML
• Heartland Developers' Conference
• lookup component
• Merge
• omaha
• scripting
• spatial

• The Top Five New Features in SSIS 2008 for Developers, Part 2

  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 Read More... Posted Tuesday, August 26, 2008 8:25 AM by ktegels | 2 Comments Filed under: SSIS, Integration Services, Katmai, cache, cache transform, lookup component

• The Top Five New Features in SSIS 2008 for Developers, Part 1

  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 Read More... Posted Monday, August 18, 2008 4:56 PM by ktegels | 0 Comments Filed under: SSIS, Integration Services, Katmai, cache

• The Top Five New Features in SSIS 2008 for Developers, Part 0

  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; Read More... Posted Thursday, August 14, 2008 1:17 PM by ktegels | 0 Comments Filed under: SSIS, Integration Services, Katmai, scripting, cache

• Come learn more about SQL Server 2008 Integration Services

  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 Read More... Posted Tuesday, July 22, 2008 8:55 AM by ktegels | 0 Comments Filed under: SSIS, Integration Services, Merge, spatial, Katmai, scripting, cache, omaha

• Call For Action: Spatial "geeks," please speak up!

  I've had a lot of "fun" working the with new spatial types in SQL Server 2008. Fun like your first root canal sometimes, fun like a great first date other times. One of the "root canal moments" for me has been around Geographic Markup Language (GML) support. Read More... Posted Tuesday, July 08, 2008 11:11 AM by ktegels | 0 Comments Filed under: SSIS, Integration Services, spatial, Katmai, GML

• Upcoming talks on SQL Spatial and SSIS

  Yesterday I drove down from Sioux Falls to Omaha so that I could catch a talk being given by Sudhir Gajre to the Omaha SQL Server/BI Interest Group. I first got to know Sudhir when he, I and Luke Schollmeyer were restarting a SQL Server Users Group in Read More... Posted Thursday, June 05, 2008 8:42 AM by ktegels | 2 Comments Filed under: Heartland Developers' Conference, SSIS, Integration Services, Merge, spatial, Katmai