Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

I am honored to deliver From Zero to ADF – a full-day pre-conference training event held Friday, 04 Oct 2019 – the day before SQL Saturday 907 – Pittsburgh! Abstract From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud …
Continue reading Honored to Deliver From Zero to ADF at SQL Saturday Pittsburgh!

UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure

Join me 17 Sep 2019 at 12:00 PM EDT for Overcome Challenges of Lifting and Shifting SSIS to Azure! We help customers lift and shift data, databases, Analysis Services (SSAS), Power BI, and Integration Services (SSIS) to Azure at Enterprise Data & Analytics. Lifting and shifting SSIS to Azure-SSIS is our fastest-growing segment of business, …
Continue reading UPDATED: Free Webinar – Overcome Challenges of Lifting and Shifting SSIS to Azure

Updated: SSIS Catalog Logging and Reporting in the Enterprise

The SSIS Catalog, first introduced with the release of SQL Server 2012 Integration Services (SSIS 2012), is a big step forward in Data Integration Lifecycle Management (DILM) with SQL Server Integration Services (SSIS). Like all software, the SSIS Catalog performs some tasks admirably and other tasks… not so admirably. In this post, I will share …
Continue reading Updated: SSIS Catalog Logging and Reporting in the Enterprise

Azure-SSIS Starts Faster

I had the honor to deliver “Moving Data with Azure Data Factory at SQL Saturday – Atlanta this weekend. Because Azure changes daily, I fired up an Azure-SSIS instance Integration Runtime the morning of my presentation and walked through my demo. I play a game I call, “What’s Changed in Azure!” It’s a fun game. …
Continue reading Azure-SSIS Starts Faster

SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2

In my previous four posts I examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0). I shared why I want to do all this (Part 1). I shared one way to execute SSIS on a container in Part …
Continue reading SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2

“Andy, I Want More ____”

I am always learning. I enjoy learning and this trait led me to technology in the first place. It turns out a love of learning is all but essential for technologists. After I learn, I share what I’ve learned in blog posts, webinars, and via presentations at SQL Saturdays and events like the PASS Summit. …
Continue reading “Andy, I Want More ____”

The Recording for Troubleshooting SSIS (Part 1) is Available

A fantastic crowd attended today’s (13 Mar 2019) free webinar titled Troubleshooting SSIS. If you attended you got the full show. If not, you may view the content at SSIS Academy for a nominal fee. Enjoy this focused content to SSIS Self-Help, a service from Enterprise Data & Analytics designed to help folks quickly and …
Continue reading The Recording for Troubleshooting SSIS (Part 1) is Available

Andy’s Database Credentials Hack

Ok, this isn’t a hack. It’s more of a tip that may help you protect data. Some of you would not have clicked a link to Andy’s Database Credentials Tip. You are welcome. LastPass I like LastPass. I pay for Premium and it’s not a bad deal, in my humble opinion. I also like Azure …
Continue reading Andy’s Database Credentials Hack

SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!

I’m honored to deliver Intelligent Data Integration with SSIS – a full-day pre-conference session – at SQL Saturday 813 in Boston 29 Mar 2019! What is Intelligent Data Integration?SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), produced using …
Continue reading SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!