Category:Uncategorized

I’m honored and excited to deliver a brand new presentation at SQL Saturday 683 – Charlotte on 14 Oct: Faster SSIS! Abstract: Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services …
Continue reading Presenting Faster SSIS at SQL Saturday 683 – Charlotte 14 Oct

I am honored to announce Kent Bradshaw, who works with me at Enterprise Data & Analytics, is now a Microsoft Certified Data Scientist! Kent worked hard for several months to achieve this honor. He worked through ten courses, including a five-week Statistics course taught by Columbia University faculty. Congratulations Kent! :{> Learn more: Enterprise Data …
Continue reading Congratulations Kent Bradshaw – Certified Data Scientist!

A couple people have asked – and I needed to update my Amazon Author page. The RSS feed for for this blog is located at https://andyleonard.blog//feed/. :{>

My latest article, Help for DBAs Who Support SSIS… is now live at SQL Server Central! In this article I share some tips and tricks for using SSIS Catalog Compare for surfacing SSIS Catalog metadata, comparing SSIS projects deployed to different SSIS Catalog, and Scripting SSIS Catalog configurations metadata (such as Environments, Environment Variables, References, …
Continue reading New Article: Help for DBAs Who Support SSIS at SQL Server Central

This week on Data Driven, Frank and I are honored to interview Rimma Nehme, CosmosDB Architect at Microsoft. We had a fantastic time chatting about CosmosDB, open-source, reading, and what (or whom, rather) Dr. Nehme finds really important. As always there are movie references: Blues Brothers and Spiderman are quoted this week. Notable Quotes Submitting …
Continue reading New Data Driven Episode: Rimma Nehme on CosmosDB, Planet-Scale Applications, and Selling Door-to-Door

As I type, SQL Saturday-Dublin 2017 is winding down for me. There’s a Viking Splash Tour planned for tomorrow but I’m off to London to deliver some Biml Training and will have to miss the fun. Reflecting on my first trip to Ireland, it occurs to me that we are part of an awesome community. …
Continue reading We Are Part of an Awesome Community

At Data Driven we’re experimenting with new show formats – especially what we call “mini-shows.” Earlier this week we started a new feature called Data Science Daily. Frank has done an outstanding job on these first three installments! We’d love your feedback. What do you think of the shows so far? If you’re so inclined, …
Continue reading Announcing Data Science Daily

This week on Data Driven, Frank and I are honored to interview Mark Tabladillo, Lead Data Scientist for Microsoft Services: Data Insights Domain Center of Excellence. We talked about lots of stuff including Data Science teams, bots, personhood, and dancing. Notable Quotes No brakes on the F train. (2:10) On data munging (15:00) On MS …
Continue reading New Data Driven Episode: Mark Tabladillo on Data Science Teams, Bots, Personhood, and Dancing

Years ago I worked in manufacturing automation. I wrote ladder logic (and machine code and even a little C) mostly for Allen-Bradley and GE Fanuc PLCs (Programmable Logic Controllers). I also used HMI (Human-Machine Software) solutions like RSView and WonderWare to develop operator workstation software and to perform data acquisition from the PLCs running the …
Continue reading Signal Processing and Near-Real-Time Data Integration

I’m writing up show notes and the Data Driver Newsletter for next week. Our guest on the next Data Driven Podcast is… Only Data Drivers get advance notice of guest appearances. Sign up today! :{> Follow Data Driven iTunes YouTube Twitter Facebook LinkedIn RSS Feed Learn More About Data Driven Data Driven website Episodes Blog …
Continue reading Data Drivers