Author:Andy Leonard

A couple months ago my friend – and for many years and in many ways, mentor – Andy Warren (blog | @sqlandy) wrote a blog post that has been slow-cooking in my soul. The title is The Ebb & Flow of Community Participation. Basting this slow-cooking are the collected works of K. Brian Kelley (blog …
Continue reading Mind the Gap

I’m honored to deliver the Immersion Event on Learning SQL Server Integration Services – IESSIS1 – in Chicago next week (24-28 Apr 2017). The April class sold out! Paul and Kimberly tell me there are already folks on the waiting list for the next delivery of the course – wow! “So when is the next …
Continue reading SSIS Training–SQLSkills Immersion Event on Learning SSIS (IESSIS1) 2-6 Oct 2017

I’m honored to present Use Biml to Automate SSIS Design Patterns at the Triangle SQL Server User Group in Raleigh, NC 18 Apr 2017! …especially since I missed SQL Saturday – Raleigh last month due to illness. Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns at #TriPASS 18 Apr!

There are a few tools and add-ins that support the creation of “regions” in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate sections of long-ish T-SQL scripts natively, by using begin/end: To demonstrate, start with a snippet of T-SQL that includes begin/end: If you click on the “-“ highlighted above, the …
Continue reading Quick Regions in SQL Server Management Studio (SSMS)

Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterprise Data & Analytics helps enterprise data integration teams reduce …
Continue reading Data Wrangling Concepts: Latency and Staleness

Merriam-Webster defines sampling as: the act, process, or technique of selecting a suitable sample; specifically :  the act, process, or technique of selecting a representative part of a population for the purpose of determining parameters or characteristics of the whole population a small part selected as a sample for inspection or analysis ask a sampling …
Continue reading Big Data vs. Sampling

The recording for the webinar Biml in the Enterprise Data Integration Lifecycle is now available (registration required). The password for the meeting is BimlRocks. You may be reading this post and thinking, “But Andy, I don’t recall seeing anything about this webinar until just now.” That’s entirely possible. I advertised this webinar in advance, but …
Continue reading The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!

The recording for the webinar Biml in the Enterprise Data Integration Lifecycle is now available (registration required). The password for the meeting is BimlRocks. You may be reading this post and thinking, “But Andy, I don’t recall seeing anything about this webinar until just now.” That’s entirely possible. I advertised this webinar in advance, but …
Continue reading The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!

Wendy Pastrick [Blog | @wendy_dance], (my friend) who leads the PASS Program effort on the PASS Board, recently wrote Changes to the PASS Summit 2017 Program, Pre-Conference Call for Interest, and a Community Survey. The PASS Summit 2017 Program will be somewhat different from previous years. “Different in what ways, Andy?” Excellent question, and the …
Continue reading Changes to PASS Summit Program Selection Process

My name is Andy and I’m a blogger. I encourage you to blog, too. Why? Because you know stuff. I need to learn some of the stuff you know. You’ve experienced stuff. I’d like to read your experiences – again, to learn from them. Others feel the same way. “I don’t have anything to say.” …
Continue reading Please Blog