Roger Doherty's SQL Server Evangelism Blog

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...

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 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...

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...