July 2008 - Posts

• When is a bug not a bug?

  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 Read More... Posted Saturday, July 26, 2008 7:04 AM by ktegels | 12 Comments Filed under: spatial, Katmai

• Recommended readings: 2008 update

  In class this week, I got asked a few times about the technical books I'd recommed for fulks interested in the data space. While I've had a list up on Amazon for while, I thought I'd post an updated list here. I'd love to hear your suggestions, too! Business Read More... Posted Friday, July 25, 2008 7:05 PM by ktegels | 1 Comments Filed under: SSIS, Integration Services, XML, Book Reviews, spatial, scripting

• 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

• Spatial Support Table

  Curious about how SQL Server 2008's Spatial bits compare with those in MySQL and PostGIS? Browse over to the Boston GIS web site review this neat comparsion table. http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare Read More... Posted Monday, July 21, 2008 5:04 PM by ktegels | 0 Comments Filed under: spatial

• Hey SSIS team, help us out!

  Time to share a lesson learned. While working with new GEOMETRY and GEOGRAPHY data types in SQL Server 2008 there nested set of issues. Unless you have spatial data to work with, the use-cases for these data types are limited. Loading data from typical Read More... Posted Sunday, July 20, 2008 9:33 PM by ktegels | 0 Comments Filed under: SSIS, spatial

• 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