Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » Filestream Storage   (RSS)

SQL Server 2012 FileTable and T-SQL on AlwaysOn secondary replicas

OK, back to PathName() with AlwaysOn, which I started on in the previous blog post . PathName() in SQL Server 2012 doesn't return the computer name by default ("AlwaysOn1" or "AlwaysOn2" in my example) but returns the VNN name Read More...
Posted 17 ianuarie 2012 06:01 from Bob Beauchemin's Blog | (Comments Off)

SQL Server 2012 FileTables - AlwaysOn support and PathName()

When I was covering the FileTable-specific functions and methods, I didn't mention PathName(), a filestream-related function, that (naturally) can be used with FileTables. This posting is about PathName(), but, mostly about what happens with FileTable Read More...
Posted 17 ianuarie 2012 04:03 from Bob Beauchemin's Blog | (Comments Off)

SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods

So finally, we get to using FileTable's path_locator column with the methods of hierarchyid. To pick up where we left off , remember that hierarchyid has a method named GetLevel(). Given the following directory structure in the FileTable's share: Read More...
Posted 16 ianuarie 2012 07:06 from Bob Beauchemin's Blog | (Comments Off)

SQL Server 2012 FileTables in T-SQL part 2: new rows

So the functions/methods that I wrote about in previous post are needed because FileTables don't store the UNC path name of the file, they store the path_locator as a hierarchyid data type. Wonder what encoding scheme they're using. Let's Read More...
Posted 16 ianuarie 2012 02:00 from Bob Beauchemin's Blog | (Comments Off)

SQL Server 2012 FileTables in T-SQL part 1: functions and methods

I've been working with the SQL Server 2012 FileTable feature lately. Besides learning to appreciate the esoteric features of the NTFS file system and SMB protocol, only some of which are supported by FileTables, I've been trying to work with FileTables Read More...
Posted 15 ianuarie 2012 16:17 from Bob Beauchemin's Blog | (Comments Off)

Of filetables, full-text and semantic search, and docidmaps

SQL Server Denali's new Filetable feature and full-text search are made for each other. Set up database for non-transactional filestream access with a directory name, create a table "AS FILETABLE" with a subdirectory name, drag over a bunch Read More...
Posted 6 septembrie 2011 09:45 from Bob Beauchemin's Blog | (Comments Off)

Filestreams, Remote Blog Storage, and SQL Server 2008 R2

As long as I'm blogging about filestreams... Folks always want to know if the filestream information can be stored on a remote share. They look kind of disappointed when they hear that the filestream filegroup must exist on a local (to the SQL Server Read More...
Posted 4 februarie 2010 08:25 from Bob Beauchemin's Blog | (Comments Off)

Filestreams, transactions and SQL Server 2008 R2

I was under the impression that the database engine/programming model changes in SQL Server 2008 R2 were minimal and could be counted on one hand. Today I was running an old demo that I had, having to do with filestreams on the R2 Nov CTP. Usually I run Read More...
Posted 4 februarie 2010 07:47 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Article about programming filestreams on MSDN

My latest article on out. It's in the May issue of MSDN magazine, and can be found here . It this article I explore the internals of programming with the filestream feature of SQL Server 2008 and some best practices around when and how to use it. Read More...
Posted 1 mai 2009 08:20 from Bob Beauchemin's Blog | (Comments Off)