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...

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 re...

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 bo...

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 h...

I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another. By copying the data flow components ...

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 h...

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 co...

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 DA...

A frequently seen question related to editing SSIS packages for 2012 is related to the SQL Server Data Tools (SSDT). SSDT is the successor to the former BIDS and to the former VSDB. However, even though Microsoft likes to think of SSDT as a single produ...

For the next few weeks, the topic of upgrading SSIS 2008 packages to SSIS 2012 will be keeping me very busy. I am preparing to speak on the topic three times at upcoming developer events: SQL Saturday #112, SQL Saturday #132 and TechEd NA 2012. The most...