In just a few short weeks I am attending the PASS Summit 2018 in Seattle. Whenever I attend an event like the Summit or SQL Saturday I attempt to attend presentations of interest to me. I love learning new stuff! Good and Less-Good Most of the presentations I attend are good. Some are really good. They …
Continue reading Bad Presentations
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. :{>
Viewing SSIS Configurations Metadata in SSIS Catalog Browser
SSIS Catalog Browser is a pretty neat product. “How neat is it, Andy?” I’m glad you asked. It’s free. That makes it difficult to beat the cost. SSIS Catalog Browser is designed to surface all SSIS Catalog artifacts and properties in a single view. “What exactly does that mean, Andy?” You’re sharp. Let’s talk about why …
Continue reading Viewing SSIS Configurations Metadata in SSIS Catalog Browser
Viewing SSIS Configurations Metadata in SSMS
Let’s take a look at an SSIS Project in SSMS: Demo is the SSIS Catalog folder. Demo contains three SSIS projects named 0-Monolith, EmptySSISProject, and LiftAndShift. If we expand the LiftAndShift SSIS project we see it contains a single SSIS package named Load Customer.dtsx. The Demo folder contains two Catalog environments named env1 and env2. These …
Continue reading Viewing SSIS Configurations Metadata in SSMS
It is Possible to Execute SSIS in a Container
As the title of this post suggests, it is possible to execute SSIS in a container. How? I’ll share more details later – promise. One short version is: Run a container with the microsoft/mssql-server-windows-developer image (assign lots of RAM). Add the SQL Server installation files to the container. Execute SQL Server setup from a command line …
Continue reading It is Possible to Execute SSIS in a Container
Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!
I am honored to present Moving Data with Azure Data Factory at SQL Saturday 806 in Charlotte, NC 20 Oct 2018. This is the first time I am delivering this session. It still has that new presentation smell! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports …
Continue reading Presenting Moving Data with Azure Data Factory at SQL Saturday Charlotte!
On Data Engineering in 2018
A few years ago I had a conversation with Scott Currie, the CEO of Varigence and inventor of Biml. Scott is one of the smartest people I know and I know a lot of very smart people. Whenever I have the opportunity to communicate with the very smart people I know, I often ask them – …
Continue reading On Data Engineering in 2018
The Recording for Using SSIS Framework Community Edition is Available
The recording of my free webinar titled Using SSIS Framework Community Edition is now available (registration required). You can obtain the free and open source SSIS Framework Community Edition at DILM Suite. Enjoy! :{>
Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who …
Continue reading Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Using SSIS Framework Community Edition Webinar 20 Sep
Join me 20 Sep 2018 at noon ET for a free webinar titled Using SSIS Framework Community Edition! Abstract SSIS Framework Community Edition is free and open source. You may know can use SSIS Framework Community Edition to execute a collection of SSIS packages using a call to a single stored procedure passing a single …
Continue reading Using SSIS Framework Community Edition Webinar 20 Sep
AndyWeather – Now Part of Weather Underground
Weather Underground is a cool weather site. They get community. Exhibit A is the latest personal weather station reporting to Weather Underground, affectionately known as PWS: KVAFARMV9. Yep, that’s the AndyWeather weather station, right there! :{>