Join me 30 Aug 2018 at noon EDT for another free webinar titled Use Biml to Build a Local Copy of an Azure SQL DB. This webinar is inspired by a social media post by a friend. His company is using Azure SQL DB in Production. They want to make a copy of the Production …
Continue reading Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
What’s the Best Book for Learning SSIS?
I am often asked the question, “Andy, what’s the Best Book for Learning SSIS?” There are some really good books out there that will help you learn SSIS (and I am co-author of several). The book from which I learned the most about SSIS is Extending SSIS 2005 with Script by Donald Farmer. Why do …
Continue reading What’s the Best Book for Learning SSIS?
DevOps and SSIS and Azure Data Factory
I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source: SSIS Framework Community Edition – free, open-source, and …
Continue reading DevOps and SSIS and Azure Data Factory
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta
The #Azure DataFest Atlanta Schedule has been posted and I am honored to be selected to present Lift and Shift SSIS to ADF! Check out this lineup of presenters and presentations. I describe this group as: “a bunch of smart people – plus me!” Lift and Shift SSIS to ADF Abstract Your enterprise wants to …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Atlanta
My Day – Sunday, 22 Jul 2018 – #SQLCareer
6:30-9:00 AM Awaken. Weigh in, pray, read the Bible, check the burn barrel. This morning I weigh 200 pounds. Prayer, praise, gratitude, thanking God for another day. This morning I read Romans 8:31-39. I am teaching our adult Sunday School class this morning and we are making our way through Romans. Powerful. Coffee. Breakfast. Boy-wrangling. It’s …
Continue reading My Day – Sunday, 22 Jul 2018 – #SQLCareer
My Day – Saturday, 21 Jul 2018 – #SQLCareer
5:30-9:30 AM Awaken after hitting snooze thrice. Weigh in, pray, read the Bible, check the burn barrel. This morning I weigh 201 pounds. There’s a bunch to pray about. I start with praise followed by gratitude, thanking God for another day. This morning I read Psalm 150 again (now reading Psalms from last to first), …
Continue reading My Day – Saturday, 21 Jul 2018 – #SQLCareer
My Day – Friday, 20 Jul 2018 – #SQLCareer
5:06 AM – awaken after hitting the snooze on my phone alarm once. 5:06 – 9:30 AM – Weigh in, pray, read the Bible, coffee, check the burn barrel. This morning I weigh 201 pounds. There’s a bunch to pray about. I start with praise followed by gratitude, thanking God for another day. This morning …
Continue reading My Day – Friday, 20 Jul 2018 – #SQLCareer
The Recording for Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is Available
The recording for the Summer-O’-ADF webinar titled Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is now available (registration required)! Abstract SSIS Catalog Compare facilitates DevOps for enterprise SSIS, saves time, improves code quality, and lifts and shifts SSIS projects to Azure Data Factory’s Integration Runtime. More than just an “Package / …
Continue reading The Recording for Use SSIS Catalog Compare to Lift and Shift SSIS to ADF is Available
My Day – Thursday, 19 Jul 2018 – #SQLCareer
#SQLCareer post for Thursday, 19 Jul 2018 4:26 – 5:30 AM – Wake up (beating the alarm), weigh in, pray, read the Bible, coffee, check the burn barrel. Christy and I have been on a keto diet since 5 Mar. I started out at 238 pounds. This morning I weigh 199 pounds. I’ve been bouncing …
Continue reading My Day – Thursday, 19 Jul 2018 – #SQLCareer
One Solution to Presentation Categories
I’ve shared suggestions for improving presentation categories: One Solution to Presentation Levels One Solution to Presentation Tracks My chief concern is the scalar nature of the selections (the “Naked Scalar”). As I pointed out in both posts, I’ve been delivering presentations to the SQL Server Community for more than a decade and I’ve never – …
Continue reading One Solution to Presentation Categories