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)
Category: SQL Server 2012
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.
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
In less than a week, I'll be presenting DBI329 - Upgrading Packages to SQL Server 2012 at TechEd North America 2012 (which is sold out by the way!). I have my session and demos prepared, but I am very interested in hearing from developers and DBA who have already migrated to SSIS 2012 what their … Continue reading Request for Comment: Upgrading Packages to SSIS 2012
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 product rolling up the functionality of BIDS and VSDB, there … Continue reading When SSDT is not SSDT
In a previous post, I wrote about using SSIS 2008 custom components in SSIS 2012. In that post, I noted that the custom component's UI (Edit, Advanced Edit) does not work in SSDT. It turns out there is a way to get some UI for some components to work though. The key is that the component's … Continue reading Editing SSIS 2008 Custom Component Properties in SSDT
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
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
It appears, after all, that Microsoft doesn't believe the FileTable security bug I described in a previous post (here) is By Design. The bug on Connect was Resolved as By Design a few weeks ago, but I didn't agree. So the upshot is that it will be fixed in a forthcoming update (presumably this means … Continue reading Update on FileTable Security Bug
Sven Aelterman 