Category:Uncategorized

I am honored to announce I will be presenting (remotely) “I See a Control Flow Tab. Now What?” at BIG PASS in Lake Forest, California 10 Dec 2015 at 6:30 PM PT! This demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the …
Continue reading Presenting at BIG PASS 10 Dec 2015!

The actual time is about 3:15… In a new video, I demonstrate how to use SSIS Catalog Compare to deploy an SSIS Project and all configurations metadata from one SSIS Catalog to another. I call it the 3-Minute Drill. Enjoy! :{> Learn more: Product  Catalog Compare 0.5 Browsing the Catalog Catalog Compare 0.5 Comparing Catalogs …
Continue reading SSIS Catalog Compare 3-Minute Drill

Thanks to everyone who attended the Biml 101 webinar! The recording and demo files for Biml 101 are available here. I’ve scheduled three additional webinars in the series: 1:00 PM ET 16 Dec 2015 – Biml 102: Using Biml as an SSIS Design Patterns Engine 1:00 PM ET 6 Jan 2016 – Introduction to SSIS …
Continue reading Announcing Three Free Biml and SSIS Webinars

We are part of an awesome community. The SQL Server Community or SQL Family, as many call it, is astounding. Our annual Big family reunion is the PASS Summit. I received feedback from attendee evaluations the other day and I would like to share some of the feedback for one reason: Many people spoke at …
Continue reading PASS Summit 2015 Feedback

I recently needed to update my PASS and SQL Saturday speaker profiles. I emailed my good friend and Awesome Community Person Karla Landrum for help, and Karla kindly responded with detailed instructions that even I could follow. I decided to capture and share my experience updating my PASS and SQL Saturday profiles. Updating Your PASS …
Continue reading Do You Need to Update Your PASS Profile or SQL Saturday Speaker Profile?

Note: This article was first published at SQL Authority. With “SQL Server” included in the name of SQL Server Integration Services (SSIS), it is easy for people to assume SSIS is simply a database tool or accessory. Let there be no mistake, SSIS is a software development platform. To give you a better understanding of …
Continue reading Learn to Code SSIS: The Execute SQL Task

I had an awesome time sharing about Biml (Business Intelligence Markup Language) earlier today! Thank you to everyone who registered and turned out for the live presentation. For those unable to make it to the live presentation, the recording is now available for viewing. I’ve posted the Mist and SSIS solutions source code. You can …
Continue reading Biml 101 Recording and Files Are Now Available!

One of the coolest features of the SSIS Catalog is Catalog Environments. Catalog Environments offer a compelling and rich solution for Catalog Project Parameter value externalization and configuration management, whether the parameters are connections or parameter values. Configuring and using Catalog Environments involves four steps: Create the Catalog Environment Create and Configure the Catalog Environment …
Continue reading Managing SSIS Catalog Project Parameter Values

A reader emailed to ask what I recommend for learning current software and database development. I responded with these links: VirtualBox Windows 2016 Server TP3 SQL Server 2016 CTP 3 Visual Studio 2015 I believe the software is all free, though it is a combination of community and (time-limited) technology previews. Save your code in …
Continue reading November 2015–Learn SQL Server and Visual Studio

        I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design Patterns and Biml: A Day …
Continue reading Precon – SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia