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
Category: FileTable
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
It appears, after all, that 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 be fixed in a forthcoming update (presumably this means … Continue reading Update on FileTable Security Bug
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 the many new and improved features. While HADRON is the … Continue reading SQL Server FileTable: Cannot prevent users with read-only access to the FileTable from modifying file contents using non-transactional access
If you haven't already done so, check your calendar for Saturday, April 14, 2012 and attend SQL Saturday #111 in Atlanta, GA. The event this year will be held again at Georgia State University's Alpharetta location. Follow the latest news on Twitter using hashtag #sqlsat111. Despite almost insurmountable odds, one of my submitted sessions was … Continue reading SQL Saturday #111 (Eleventy-one) in Atlanta