I’ll be at the PASS Summit 2018 next week. I’m delivering a full-day precon Monday, presenting Faster SSIS and participating in the BI & Data Visualization Panel Wednesday, and Enterprise Data & Analytics is exhibiting Wednesday through Friday. “You Mentioned a Free Book…” Oh. Yeah. That. I will be giving away free copies of my latest book: Data Integration …
Continue reading Want a Free #DILM Book? See Me at the #PASSsummit 2018!
Category:SSIS
DILM Tiers for Enterprise Data Integration
“How many Data Integration Lifecycle Management tiers (DILM tiers) do I need to manage enterprise data integration, Andy?” If I had a nickel for every time I am asked this question, I would have a lot of nickels. My answer is, “Four.” Why Four? I’m glad you asked. Before I answer, I have a question …
Continue reading DILM Tiers for Enterprise Data Integration
SSIS Project Incompatible
Has this ever happened to you? You are opening an SSIS project and… it won’t open. Instead of a Control Flow filled with awesome tasks and containers, you see a message in Solution Explorer telling you “The application is not installed.” You know this isn’t right because you built the SSIS project on this same machine …
Continue reading SSIS Project Incompatible
Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
I am honored to join my friends at the Triad SQL PASS BI Group in Greensboro North Carolina 30 Oct 2018, where I will present Faster SSIS! Abstract Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to …
Continue reading Honored to Present Faster SSIS at Triad SQL PASS BI 30 Oct!
Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
I am honored to deliver Lift and Shift SSIS to ADF at the Azure DataFest in Reston Virginia 11 Oct 2018! Abstract Your enterprise wants to use the latest cool Azure Data Analytics tools but there’s one issue: All your data are belong to the servers on-premises. How do you get your enterprise data into …
Continue reading Honored to Present Lift and Shift SSIS to ADF at #Azure DataFest Reston
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