Author:Andy Leonard

You can access Biml Academy recordings and more at the Biml Academy website! The recording for Biml Academy – Lesson 2 – Use Biml with SSIS Design Patterns is now available! Registration is required. Remember Biml Academy is running all week! Two more free ~1-hour sessions are headed your way: Tomorrow – Biml Academy – …
Continue reading The Recording for Biml Academy – Lesson 2 – Use Biml with SSIS Design Patterns is Available!

You can access Biml Academy recordings and more at the Biml Academy website! The recording for Biml Academy – Lesson 1 – Build Your First SSIS Package with Biml is now available! Registration is required. Remember Biml Academy is running all week! Three more free ~1-hour sessions are headed your way: Tomorrow- Biml Academy – …
Continue reading The Recording for Biml Academy – Lesson 1 – Build Your First SSIS Package with Biml is Available!

You can access Biml Academy recordings and more at the Biml Academy website! The recording for Biml Academy Lesson 0-SSIS Design Patterns is now live! Registration is required but I promise to only send you updates about the cool stuff we’re working on at Enterprise Data & Analytics and Andy Leonard Consulting which includes DILM …
Continue reading The Recording for Biml Academy Lesson 0–SSIS Design Patterns is Live!

Want to learn more about SSIS (from me!)? IESSIS1: Immersion Event on Learning SQL Server Integration Services is 2-6 May in Chicago! It’s not too late to register. This 1-300-level, 5-day, SQL Server Integration Services (SSIS) training class was created to train technology professionals in the fine art of using SSIS to build data integration …
Continue reading IESSIS1 2-6 May 2016 in Chicago!

Kevin Hazzard (Blog | @KevinHazzard), Kent Bradshaw, and I are excited to announce DILM Suite! I can hear you thinking, “What is DILM, Andy?” I’m glad you asked! Data Integration Lifecycle Management (DILM) is the art and science of managing data integration in the enterprise. “Ok, so what is this DILM Suite of which you …
Continue reading Introducing DILM Suite

I’ve been testing SSIS 2016 as the CTPs (Community Technology Previews) and RCs (Release Candidates) have been made available. I’ve been most interested in changes to the SSIS Catalog. Getting RC2 running posed a couple challenges for me so I thought I would blog about my test setup – in case anyone else is experiencing …
Continue reading Tinkering with SSIS 2016 RC2

Timo Elliot [Blog | @timoelliott] wrote yesterday that BI is Dead and Julie Koesmarno [Blog | @mssqlgirl] was kind enough to tweet about it. The compelling point in Mr. Elliott’s post is: “The most charitable view is that Gartner feels it has to exaggerate the demise of BI in order to get customers to pay …
Continue reading BI’s Not Dead

I’ve blogged about the value of SQL Server Developer Edition for years. It’s Enterprise Edition with a End User License Agreement (EULA) that states you cannot use the SKU for production. Developer Edition used to sell for around $50 USD, but it is now free! Download SQL Server 2014 Developer Edition today! :{>

You can access Biml Academy recordings and more at the Biml Academy website! Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now! [Recording] Biml Academy – Lesson 0 – SSIS Design Patterns – …
Continue reading Announcing Biml Academy!

The recording for the (free!) Enterprise Data & Analytics webinar “DILM with Catalog Compare” is now available. Registration is required. Enjoy! :{>