T-SQL window functions talk summary and sample scripts

Yesterday, I spoke to the Steel City SQL User group on T-SQL window functions. Below is a short summary and links to the sample scripts and database. The T-SQL window functions came about in SQL Server 2005, but you really want SQL Server 2012, because many functions were added and also because support for PARTITION … Continue reading T-SQL window functions talk summary and sample scripts

Advertisements

Removing an Upgraded Component from SSIS Designer Results in Error

While working with an SSIS package that uses a custom component (in this case the RegexClean transformation from Konesans) that was upgraded from SSIS 2008 to SSIS 2012, I ran into this error trying to delete it from the designer when I realized I couldn't work with it: "SSIS Designer does not allow this component … Continue reading Removing an Upgraded Component from SSIS Designer Results in Error

Copy or Duplicate an SSIS environment in the SSIS 2012 Catalog (SSISDB)

As part of my research for my Managing SSISDB talk, I came across an interesting script by Mike Davis. The script intends to copy an environment in the SSISDB. Mike does a good job explaining why this is useful. The SSIS Catalog does not provide a UI for that. Mike's script seems to work, but it has … Continue reading Copy or Duplicate an SSIS environment in the SSIS 2012 Catalog (SSISDB)

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