I’m honored to be invited back to this year’s SQL Saturday Dublin event. I must have done a decent job last year on my SSIS Design Patterns pre-conference session, because I’ve been asked to do another one this time around as part of their Training Day (June 21st). This year I’ll be doing a full … Continued
The slides from my 3rd presentation at the TechDays Hong Kong event are now available. As I mentioned during the talk, design patterns are one of my favorite topics, and something I really enjoyed writing about. This presentation had a subset of the SSIS Performance Design patterns in the full day training sessions I’ve done … Continued
The slides from the Using SQL Server Integration Services with Oracle talk from TechDays Hong Kong 2013 can be found below (use the embedded control to download the powerpoint presentation directly from SkyDrive). Thank you to everyone who attended!
Update: Amazon is now reporting a release date of 9/17 although it appears you can order it immediately from the O’Reilly site. My second SSIS book – Microsoft SQL Server 2012 Integration Services (MS Press) – comes out on September 17th. This book takes a different approach than my Design Patterns book that came out … Continued
No. No you cannot. In SQL Server 2012, you will always deploy the entire .ispac file to the Catalog. I’ve received this question a number of times in the past couple of weeks. It’s actually a feature we considered, and one that I (initially) argued for, as I know it is a common practice with … Continued
If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products. Data Quality Services for SQL Server 2012 Data Quality Basics and Introducing DQS: Video | Slides Knowledge … Continued
One of the powerful features of the SSIS Catalog is that it can automatically capture logs for packages run on the server. The logging level is set to Basic by default, and can be changed when the package is run on the Advanced tab of the run UI (as shown below. This can also be … Continued
Logging Levels Packages run through the SSIS Catalog can automatically have their logs captured in SQL Server 2012. The SSIS Catalog provides four different log levels – None, Basic, Performance, Verbose. The default log level is Basic. The table below shows which SSIS events are captured in the [catalog].[operation_messages] view in the four logging levels. … Continued