I am often asked for more information about writing a technical book. As author or co-author of twelve books focused or touching on technology, I consider myself experienced – not an expert. I’ve noticed “ah-ha” moments recently when sharing insights and advice, so I thought I’d write a post about it. I hope that’s ok. …
Continue reading Writing a Technical Book
A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion
I’m typing this at 4:30 AM IST in my hotel room in Bengaluru, India. It’s not unusual that I am awake at 4:30 AM. It is unusual that I’ve been awake since around 1:15 AM. I am attending and presenting at the Data Platform Summit 2018 and, obviously, still adjusting to the time zone. It is …
Continue reading A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion
Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
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
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