|
|
-
|
|
Just a quick post to publicize the PASS DBA Virtual Chapter meeting on Wednesday where I will be presenting an online session on Configuring and Managing FILESTREAM and FileTable in SQL Server 2012.
The link for registration (enters you in a drawing for a ...
|
|
-
|
|
Even though Service Pack 1 for SQL Server 2012 was released almost 2 months ago, it’s only now that I’ve had a chance to check if the FileTable security flaw was addressed. And I am pleased to report that the problem was resolved with the relea...
|
|
-
|
|
With the introduction of the FileTable feature in SQL Server 2012, a few new supporting functions and stored procedures were also added. One of these functions is an intrinsic function called GetFileNamespacePath which you can call on the file_stream colum...
|
|
-
|
|
When creating a FILESTREAM-enabled database and creating the file to hold the FILESTREAM data, you can set an optional maximum size. In script, this is how you create a database with a single FILESTREAM file with a maximum size of 2 megabytes:
CREATE DATAB...
|
|
-
|
|
It appears, after all, the Microsoft doesn’t believe the FileTable security bug I described in a previous post (here) is By Design. The bug on Connect was Resolved as By Design a few weeks ago, but I didn’t agree.
So the upshot is that it will ...
|
|
-
|
|
So this blog post has a long title, apologies for that. This is an important FileTable issue that you must be aware of before implementing this feature.
Now that SQL Server 2012 is officially released, people are looking to deploy it and take advantage of ...
|
|
-
|
|
In SQL Server 2012, the new FileTable feature provides some very interesting new capabilities (which I will blog about later). However, the SSMS GUI only provides a T-SQL script template to create a new FileTable. And while this template is very complete, ...
|
|