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: FILESTREAM
While reviewing some blog posts I meant to read a long time ago, I came across a post from Peter Meinl. He has a well-written blog post that first compares FILESTREAM, FileTable, VARBINARY(MAX) and file system storage for BLOBs and then discusses a sample application where he integrates WCF, EF and FILESTREAM. Well worth the … Continue reading FILESTREAM, Entity Framework and WCF Sample Application
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
If you've been thinking about getting a hard copy of the The Art of SQL Server FILESTREAM, you can get immediate gratification here. However, if you're the betting type, you can enter in Red Gate's Book Giveaway, which includes this book. Enter today, and let me know if you win a free copy of The … Continue reading Red Gate Book Giveaway includes The Art of SQL Server FILESTREAM
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
In the last blog post about FILESTREAM, I discussed the impact of the MAXSIZE setting for the data container. I encourage you to review that blog post first. This time, let's review a new feature that was added in SQL Server 2012: the ability to have multiple data containers in a single filegroup. This feature … Continue reading FILESTREAM with Multiple Data Containers (Files)
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