Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
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. :{>
How I Learn
This is a picture of how I learn. These are executions of an Azure Data Factory version 2 (ADFv2) pipeline. The pipeline is designed to grab data collected from a local weather station here in Hampden-Sydney Virginia – just outside Farmville – and piped to Azure Blob Storage via AzCopy. How do I learn? Fail …
Continue reading How I Learn
Catalog Browser, Version 0.6.2.0
If you’ve read this blog for a short time, you already know I have a passion for DevOps. You probably guessed I also have a passion for data engineering (My job title at Enterprise Data & Analytics is Chief Data Engineer). I believe successful software development is a combination of a software development platform, a …
Continue reading Catalog Browser, Version 0.6.2.0
T-SQL Tuesday 102: Giving Back
I enjoy the privilege and honor of participating in the SQL Server Community alongside many who read this blog. And I know from past experience that some reading this post will make the switch from consumers-only in our community to sharers and consumers one day. For my part, I consume more than I contribute. I …
Continue reading T-SQL Tuesday 102: Giving Back
Stack Overflow Wants to Change
This week Stack Overflow shared a blog post titled Stack Overflow Isn’t Very Welcoming. It’s Time for That to Change. I admire the courage and the transparency a great deal. It takes guts to admit mistakes and serious guts to publicly air the dirty laundry. Kudos to Stack Overflow. Why I Stopped Contributing to the Stack Overflow Conversation I …
Continue reading Stack Overflow Wants to Change
Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!
I am honored and excited to announce that Enterprise Data & Analytics will be an exhibitor at the PASS Summit 2018! If you browse on over to the PASS Summit Sponsors page and scroll to the Exhibitors section, you’ll find us listed: Honored and excited – that’s me! I see – and have lived – …
Continue reading Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!
Deploying to the SSIS Catalog Changes the Protection Level
I recently answered a question on the SQL Community Slack #ssis channel about SSIS and security. Let me begin by stating that SSIS security is complex, made up of many moving parts, and not trivial. If you struggle with SSIS security configuration, you are struggling with one of the harder parts of SSIS. Protection Level …
Continue reading Deploying to the SSIS Catalog Changes the Protection Level
Honored to be a Certified Microsoft Big Data Professional
I’m so excited and honored to be a Microsoft Certified Big Data Professional! I enjoyed the courses and learned a lot the past seven months. It was super cool to work with Frank La Vigne – co-host of the Data Driven podcast – on the capstone project. (Any time I get to work with Frank, it’s …
Continue reading Honored to be a Certified Microsoft Big Data Professional
Data Flow Buffer Size
I started answering a question on SQL Community Slack’s #ssis channel and I realized this would be better served as a blog post. The question was about three SSIS Data Flow properties: DefaultBufferSize, Engine Thread and DefaultBufferMaxRows. I rarely change the EngineThreads property. DefaultBufferSize and DefaultBufferMaxRows are two ways of managing the size limits of a Data …
Continue reading Data Flow Buffer Size
Completed: Microsoft Big Data Professional Program Capstone Project
I’m excited to announce that I’ve completed – with help from my friend and brother and co-host of the Data Driven podcast, Frank La Vigne (Blog | @Tableteer) – the Microsoft Big Data Professional Program Capstone project! The capstone is the last course requirement (of 10 courses) to complete the Microsoft Professional Program in Big …
Continue reading Completed: Microsoft Big Data Professional Program Capstone Project