Andy Leonard (@aleonard763)

Tired of typing server names? 😩 Connect to your DILM Suite instances with a simple alias like 'SCC Dev'. So much easier! #DataEngineering #SSIS #DILM #SQLServer

Automated SSIS catalog and framework deployment in 15 mins. Metadata, configurations, environments, and references? All migrated. Ready for execution. Learn more: dilmsuite.com/dilm-bundle. #DataEngineering #SSIS #SQLServer #Automation

Parallel range-based loads? It's not always straightforward. The target table often dictates if it's even possible. Learn more about SSIS Framework at ssisframework.com. #DataEngineering #DataEngineering #Database #SQL #DataManagement

51 years of coding: my scripts rarely cooperate on the first attempt, but they always obey. Taking breaks to remind my kids about the golden rule: it does what you *tell* it to, not always what you *want* it to. Subscribe at engineerofdata.substack.com for more data engineering insights…

Testing the waters with a fresh catalog copy! Ready to tweak those connection strings and parameters for our next big data engineering adventure. Version 1.1 or 12.3? Let's find out! Learn more at ssiscatalogcompare.com. #DataEngineering #TechTips #DatabaseAdmin #CloudComputing

Data engineering's got its own mysteries! Turns out comparing complex insurance data ain't easy. Architect's question sparked an idea: SSIS Catalog Compare. Visit ssiscatalogcompare.com to learn more. #DataEngineering #SQLServer #ETL #SSIS

Data loading woes? Unlock 4-hour nightly loads by ditching sequential and embracing parallel range-based processing. A game-changer for 20 billion rows! #DataEngineering #DataEngineeringTips #ETL #BigData

Developing with big data? Don't drown in it! Start with a sample (millions, not billions!) to catch those edge cases and nulls. Test the full set later. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #BigData #DataScience #DevOps

80% performance boost with SSIS Framework? Mind-blowing! See the magic happen. Learn more at https://ssisframework.com. #DataEngineering #SSIS #PerformanceTuning #SQL

Uh oh, stuck in a deployment jam and can't verify catalog matches? Classic data architect moment! Solution? ssiscatalogcompare.com #DataEngineering #DataManagement #SQLServer #ETL

Don't wait for a data breach to learn about governance! The best time to get educated was yesterday, but the second best time is RIGHT NOW. 🌱 #DataEngineering #DataGovernance #CyberSecurity #TechTips #EngineerOfData

Snag over $12k in software for FREE! We're giving away perpetual licenses to the DILM Suite. Get access to me, Penny, and the whole team. Don't miss out! Learn more at dilmsuite.com/deployment-partner-program. #DataEngineering #SSIS #SQLServer #TechDeals

Warehouse loads gone wrong? Imagine being 3 hours deep, 280/300 packages loaded, only to fail due to a rogue null or malformed file. That SLA window is closing fast! 😱 Subscribe at engineerofdata.substack.com for more data engineering insights. And join me tomorrow at 12:00 PM EDT for Data…

Ever wonder what happens when you restart an application? This visual shows how restartability saves the day, skipping past successful loads to focus only on the failures. Smart, right? Learn more at https://ssisframework.com. #DataEngineering #Orchestration #FailFast #Resilience

Ever wondered why your dev script looks so different from prod? It's not magic, it's probably an extra SSIS info event lurking in the shadows! 🕵️‍♂️ See the tiny differences that make a huge impact. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering…

Metadata mayhem in the SSIS catalog! Missing pieces and misconfigurations are causing chaos. How do we ensure production matches QA? Let's dive in. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #SSIS #DataCatalog #ETL

51 years of experience vs. a fresh perspective! Sometimes, less baggage means more innovation. Who knew a lack of experience could be a superpower? Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #SoftwareDevelopment #AI #Innovation

Data engineering nightmares: Rerunning 3.5 hours of loads that blow past your maintenance window. Customers expect accurate reports, but your BI dashboards are glitching. Don't violate SLAs! #DataEngineering #DataEngineeringTips #DatabaseManagement #TechHumor

faith-hope-love-fade

Data integration just got an upgrade! DILM Suite is making DevOps easier than ever. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #DevOps #DataManagement #TechInnovation

Steve Jobs, pirates vs. the Navy, and the PC revolution! 🏴‍☠️ If you believe in freedom of choice for technology, you're a friend forever. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #TechHistory #Innovation #FutureOfTech

SSIS and COBOL: Not dead, just old and essential! 👴 Both power critical systems, proving age ain't nothing but a number in tech. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #SSIS #COBOL #TechHistory

Separation of Concerns: breaking down massive methods into small, single-job functions. It's a data engineering code apocalypse! But don't worry, an SSIS framework can orchestrate it all. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #SSIS…

deddyFinal

Tired of Fabric UI clutter? A new tab for every task keeps things fresh and tidy. Less mess, more data! #DataEngineering #DataEngineeringTips #CloudData #ETL

#DataEngineering moves FAST. What used to take years now happens in DAYS. It's crazy! Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #TechNews #Innovation #FutureTech

Linux wins again! Claude's agent-teaming is smoother than ever. Windows is NOT vibing with the changes. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #Linux #TechTips #Claude

Windows 11's got the retro feels! Rocking the IBM look with CRT emulation. Portal 2 backdrop for extra nerd cred. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #Windows11 #RetroTech #Portal2

Fabric environment audit? Oh hey, it found Andy Weather's stuff! Claude navigating the UI? I'm excited, dude! #DataEngineering #MicrosoftFabric #DataPipelines #CloudAI

AI fixing itself mid-flight? We're officially wizards! See it auto-populate the next task. Mind. Blown. Subscribe at engineerofdata.substack.com for more data engineering insights. #DataEngineering #AIisMagic #TechWizards #FutureIsNow