This post was originally published at SQLBlog. 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 …
Continue reading Data Wrangling Concepts: Latency and Staleness
Schedule an SSIS Application with SSIS Framework Community Edition
Note: This post was originally posted at SQLBlog. The coolest thing about SSIS Framework Community Edition is it’s free. You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed by the number of folks using …
Continue reading Schedule an SSIS Application with SSIS Framework Community Edition
The Heart of SSIS Framework Community Edition-Parent.dtsx
Note: This post was originally posted at SQLBlog. I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to schedule the execution …
Continue reading The Heart of SSIS Framework Community Edition-Parent.dtsx
Adding an SSIS Application to SSIS Framework Community Edition
Note: This post was originally posted at SQLBlog. I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL …
Continue reading Adding an SSIS Application to SSIS Framework Community Edition
Being a More-Aware Free Technical Event Attendee
“Don’t be a jackhole.” Stated much nicer in the full post, but essentially, yeah…
Data Driven – ICYMI 24 Jul 2017
ICYMI (In Case You Missed It) at Data Driven this week… It was a busy week at Data Driven! Here’s a recap: Our podcast guest last week was Reza Rad and it was a great show talking about Training, Power BI, and the Physics of Data. Links: Reza‘s website Reza‘s free e-book: Power BI from …
Continue reading Data Driven – ICYMI 24 Jul 2017
Biml Precon by Shannon Lowder 11 Aug
I was disappointed to cancel my SQL Saturday – Louisville precon scheduled for 4 Aug. To the SQL Saturday – Louisville organizers who were kind enough to select my precon and the good people who registered, I apologize. There’s another good Biml precon only a couple hours up the road one week later, 11 Aug. …
Continue reading Biml Precon by Shannon Lowder 11 Aug
More On BimlFlex
Varigence recently released BimlFlex – a Biml Framework that automates data warehouse development. Scott Currie presented on BimlFlex last year at Biml Academy. Learn more here. :{>
RSS Feed for this Blog
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/. :{>
The Recording for Enterprise SSIS, Biml, and DILM is Available!
Kent and I had an awesome time delivering Enterprise SSIS, Biml, and DILM! I think it shows. You can check out the recording here (registration required). You can get the tools and utilities we demonstrated at DILM Suite – most are free and some are even open-source! You can grab the latest release of BimlExpress from Varigence! :{>