SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join me as I demonstrates practical SSIS performance design patterns. Register today to learn: Load BLObs faster An Incremental Load design pattern using HashBytes Using a Script Component Destination This webinar is free! Register today!
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. :{>
Free Webinar: Troubleshooting SSIS – 13 Mar at 12:00 PM ET
Join Microsoft Data Platform MVP, author, blogger, and Enterprise Data & Analytics Chief Data Engineer Andy Leonard for a free webinar titled Troubleshooting SSIS 13 Mar 2019 at 12:00 PM ET. Register today! Here’s a free preview!
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
2007-2012, 2019-
I am deeply honored to be awarded Data Platform MVP by Microsoft for 2019-2020. I was a SQL Server MVP – that’s what they used to call Data Platform MVPs back in the olde days when we used to carve our own IC’s out of wood – from 2007 to 2012. I stepped away from …
Continue reading 2007-2012, 2019-
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!
Lift and Shift SSIS to Azure
Enterprise Data & Analytics‘ data engineers are experts at lifting and shifting SSIS to Azure Data Factory SSIS Integration Runtime. Our state-of-the-art DILM Suite tools in the capable hands of our experienced data engineers combine to drastically reduce the amount of time to manually migrate and apply SSIS Catalog configuration artifacts – Literals, Catalog Environments and Catalog Environment Variables, …
Continue reading Lift and Shift SSIS to Azure
T-SQL Tuesday #111 Roundup
Thank You! First, we owe a debt of gratitude to my friend Adam Machanic (blog | @adammachanic | Data Education) for starting T-SQL Tuesday in the first place. Thank you, Adam! Next, we owe a huge shout-out to Steve Jones (blog | @way0utwest | SQL Server Central) for carrying the torch by maintaining tsqltuesday.com. Finally, thank you …
Continue reading T-SQL Tuesday #111 Roundup
Andy Answers: Format a Flat File Name
My Twitter DMs are open @AndyLeonard. Ask me a question about SSIS, ADF, or Biml. I may answer it with a blog post, a video, or both. Today’s Andy Answer is an answer to an SSIS question received via @AndyLeonard direct message: Using SSDT, I have 3 variables: one for the file path, one for …
Continue reading Andy Answers: Format a Flat File Name
Enterprise Data & Analytics Welcomes Eugene Meidinger!
I am honored and thrilled to welcome Eugene Meidinger (@SQLGene | blog | LinkedIn | Pluralsight) to the Enterprise Data & Analytics team! Eugene is self-described as a Business Intelligence Consultant but I think he’s being modest (in my humble opinion… see what I did there?). Eugene has authored three Pluralsight courses on the topics Power BI, DAX, Power Pivot, and SSAS. His …
Continue reading Enterprise Data & Analytics Welcomes Eugene Meidinger!
SSIS Project Connection Manager Naming Error
I am sometimes asked, “Andy, how do I start a technical blog?” I demonstrate one way here – a way that has served me well with search engines. 1. Describe how the error occurred.2. Copy the error message, post it as text. 3. Describe the solution. I am helping a large enterprise client migrate their data integration …
Continue reading SSIS Project Connection Manager Naming Error