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 $50 Amazon gift card) is https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=58svx93t12hx5f16. If you just want to … Continue reading Presenting for PASS DBA Virtual Chapter on Wednesday
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 release of Service Pack 1, so that is good news … Continue reading FileTable Security Flaw Resolved in Service Pack 1
On Tuesday, I delivered a new talk to the Birmingham, AL SQL Server Users Group (a PASS chapter): Configuring and Managing FILESTREAM and FileTable in SQL Server 2012. We had a good turnout, and despite having some trouble pasting UNC paths in Windows 8's Windows Explorer, I think I got some important points about FILESTREAM … Continue reading Steel City SQL Server Users Group Presentation
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 column of a FileTable. The function returns the UNC path of the file in question. But … Continue reading .PathName() versus .GetFileNamespacePath()
A quick update on the FileTable vulnerability I described earlier: the vulnerability first reported during the SQL 2012 RC0 timeframe has still not been resolved in SQL Server 2012 Cumulative Update 2.
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: We can then create a new table in this database and have a … Continue reading FILESTREAM and MAXSIZE
I am excited to have three sessions accepted for SQL Saturday #112, Birmingham 2012. This will be my third year attending the Birmingham edition of SQL Saturday and I am very much looking forward to it. The Steel City SQL Users Group is sponsoring the event, and they have the same great location as previous … Continue reading My SQL Saturday #112 (Birmingham 2012) Sessions