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
After a one-year hiatus, SQL Saturday is back in Birmingham on Saturday, August 23, 2014. I am presenting two sessions, the information for which I've included below.
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
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)
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
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
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