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

Using SSIS 2008 Components in SQL Server Data Tools with SSIS 2012

Update: 2012-05-07: Apparently, this method does work for SSIS 2005 tasks. However, these extensions should not use the native interfaces. Thanks to Matt Masson for the correction. 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 … Continue reading Using SSIS 2008 Components in SQL Server Data Tools with SSIS 2012