Speaking at SQL Saturday Atlanta #220: Managing the SSIS Catalog

SQL Saturday Atlanta 2013 is around the corner: this Saturday, May 18. Like in previous years, the event will be held at the GSU location in Alpharetta, GA. It looks to be a full event with a great roundup of speakers and sessions. I wasn't originally scheduled to speak. Due to a cancellation in the … Continue reading Speaking at SQL Saturday Atlanta #220: Managing the SSIS Catalog

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

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

SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added

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 in the same project. By copying the data flow components from one package to another, the SSIS designer also copied a … Continue reading SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added

Updating the SSIS Tutorial: Creating a Simple ETL Package to SQL Server 2012

Edit/Update (2012-12-11): MSDN has now published a 2012 version of the same tutorial: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.110).aspx For SQL Server 2008 R2 Integration Services, Microsoft created a series of tutorials (http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx). One of those was a nice step-by-step example of creating a basic ETL package. When I teach the undergraduate data warehousing class at Troy University, I have … Continue reading Updating the SSIS Tutorial: Creating a Simple ETL Package to SQL Server 2012

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

TechEd North America 2012 Session Recording Available

For those interested in upgrading SSIS packages to SQL Server 2012 and who weren't able to make it to my session (or to TechEd at all), the recording is now available on Channel9: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI329 The slide deck is also there for download. If you have any questions or comments, please feel free to post them … Continue reading TechEd North America 2012 Session Recording Available