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.
And if you do, do you remember what a *#!@%$ that was? If you don't: here is some reference material: http://support.microsoft.com/kb/161137 So, I got hit with this again... and yes, I really wrote this post in 2012! Microsoft released a number of security updates in July 2012, one of which addresses a vulnerability in the … Continue reading Anyone remember what “binary compatibility” means in COM/VB6?
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: We can then create a new table in this database and have a … Continue reading FILESTREAM and MAXSIZE
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
My TechEd session, DBI329 - Upgrading SSIS Packages to Microsoft SQL Server 2012, is scheduled for today, June 11, at 3 PM in room S230A. If you'd like to connect with me afterwards to discuss Integration Services in SQL Server 2012, I having included my Technical Learning Center (TLC) booth staffing schedule below. I'll be … Continue reading TechEd North America 2012 TLC Booth Staffing Schedule
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
It's the start of June, and for the past few years that has meant SQL Saturday in Pensacola, FL. For some reason, this year it's not the first Saturday in June, but the second one: June 9, right before TechEd North America 2012. I am scheduled to deliver two sessions at the event. 2:00 PM: … Continue reading SQL Saturday #132 in Pensacola, FL Around the Corner
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
Sven Aelterman 