October 2007 - Posts

• 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 Read More... Posted Sunday, October 28, 2007 9:47 PM by rdoherty | 11 Comments

• 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. Read More... Posted Thursday, October 18, 2007 3:48 PM by rdoherty | 2 Comments

• 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 Read More... Posted Friday, October 12, 2007 2:45 PM by rdoherty | 5 Comments

• 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 Read More... Posted Wednesday, October 10, 2007 3:52 PM by rdoherty | 2 Comments