Wednesday, September 17, 2008

Run to Run As Radio for a great SQL Server 2008 FILESTREAM show

Run As Radio - Paul Randal Talks File Streams in SQL Server 2008!

“Richard and Greg talk to Paul Randal about the new file stream technology in SQL Server 2008. File streams provide a solution to very large files being connected with SQL Server transactionally while still storing the files themselves in the file system, rather than the database. Check out Paul's blog at http://www.sqlskills.com/blogs/paul

…”

I just caught this cast and consider it a “must listen” if you’re thinking about, looking into, working on, etc the new FILESTREAM attribute in SQL Server 2008.

Paul talks about the DBA/IT side of FILESTREAM, things you might never think about (like turning off 8.3 file name creation, etc) as well as other like subjects. From drive spec’s to installing it (it’s a two part job), to when you should/shouldn’t use it to actually using it in your tables. Lots of great info crammed into 35 minutes.

Related Past Post XRef:
SQL Server 2008 FILESTREAM Attribute from Start to C#
SQL Server 2008, the FILESTREAM Attribute and Partitioning - Apparently not as easy as it looks (yet at least)...
A future world without the SQL Server Image/Text/NText data types. Now's the time to start planning for that future...
SQL Server 2008 FILESTREAM - Writing a file to a FILESTREAM column
More SQL Server 2008 FileStream Fun
Playing with the SQL Server 2008 FileStream Attribute

No comments: