Demystifying Spatial Support in SQL Server 2008

In our last series of posts Zach and I talked about using SQL Server’s new FILESTREAM support to store, manage and retrieve media in SQL Server to enable rich user experiences.  We’ve been at it again this week trying to get some traction with the new spatial data types and query semantics in SQL Server…

11

Handling NULL instances of varbinary(max) FILESTREAM columns

The table structure I proposed in my last post used the following column definition for my FILESTREAM column: CREATE TABLE [dbo].[eventMedia] (…    [file] [varbinary](max) FILESTREAM); So by default I am allowing NULL’s to be stored in the file column. Zach and I changed the design a bit to the following: CREATE TABLE [dbo].[eventMedia] (…    [file]…

3

Getting Traction with SQL Server 2008 Filestream

Zach and I just spent a couple of days figuring out how to make use of the new FILESTREAM support in SQL Server 2008 and we thought we’d share a little bit about the experience in hopes it might save somebody some time. There’s a ton of information out there regarding FILESTREAM, but in case…

6

SQL Server 2008 – The Engine that Powers Immersive User Experiences

One of the things Zach and I are trying to accomplish is to get developers to understand that SQL Server 2008 isn’t just some bland bit bucket for storing and retrieving data.  It’s THE engine that powers immersive user experiences!  Catchy huh?  I’ll give Zach the credit for coming up with that one. Whether you…

2

SQL Server 2008 Evangelism Kicks Off

It’s hard to believe that SQL Server 2005 has been out there for a couple of years, but it has.  Things have really stabilized with Service Pack 2, and all of the Office 2007 Business Intelligence functionality that exploits SQL Server 2005 is shipping (with the exception of Office PerformancePoint Server 2007 which is nearing…

1