Presenting for PASS DBA Virtual Chapter on Wednesday

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

Advertisements

FileTable Security Flaw Resolved in Service Pack 1

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

Red Gate Book Giveaway includes The Art of SQL Server FILESTREAM

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

Steel City SQL Server Users Group Presentation

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

FILESTREAM with Multiple Data Containers (Files)

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)

.PathName() versus .GetFileNamespacePath()

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()