Category:Uncategorized

Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can now view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework Community Edition …
Continue reading The Recording for Designing an SSIS Framework is Now Available

I am honored to present Intelligent Data Integration – a day-long precon at SQL Saturday #643 in Louisville Kentucky 4 Aug 2017! Synopsis: What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an SSIS Framework. …
Continue reading Presenting Intelligent Data Integration Precon at SQL Saturday–Louisville!

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!