SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily Denali Delight – Day 4

Code-named Denali – the next version of SQL Server is fast approaching.

And whenever CTP2 gets released you can be sure to expect some excellent new features.

Over the next week or so, I aim to delve into these delights, highlighting those to look out for.


Another new feature in Denali is FileTable – touted as “the next generation of FileStream”. 

What this allows you to do is copy files into specified folders on your server, and automatically store them in SQL Server. You can add, delete and modify them, using the full relational integrity that SQL Server possesses. 

Also normal maintenance tasks such as backups can be performed on these new type of files for continued ease of administration.  

The ability to run queries against NTFS file systems is a really powerful feature. I’ve also seen it mentioned in other blogs that this could negate the need to use Powershell too ??

For more info read http://msdn.microsoft.com/en-us/library/ff929144(v=sql.110).aspx


Posted by Martin Catherall on 28 April 2011

This sounds a real interesting feature and I'm guessing a lot of people will be taking advantage of it. Sounds rather like winFS to me - maybe that's where it had it's roots, I think filestream came out of that (although I may be incorrect on that)

Posted by rwb1912 on 15 May 2011

Mmmm ... I fear this might be another one of those features that because it gets used incorrectly will cause people to complain about performance problems and it will eventually disappear into obscurity.

Leave a Comment

Please register or log in to leave a comment.