Andy Leonard shares solutions for managing enterprise SSIS – the Data Integration Lifecycle Management (DILM) Suite.
Category:Biml
Why Automate?
This post was originally published at SQLBlog. Because, as Jen Underwood (jenunderwood.com | LinkedIn) states in the Data Driven podcast Jen Underwood on Data Visualization and Automating Data Science: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. What’s the long pole in data science? …
Continue reading Why Automate?
Data Wrangling Concepts: Latency and Staleness
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
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. :{>
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! :{>
Upcoming Events Featuring the Latest Biml Products!
The latest versions of BimlExpress and BimlStudio have been released less than 24 hours – along with the debut of BimlFlex – and already there are free online events showcasing some of the products. They still have that new build smell! Enterprise SSIS, Biml, and DILM – join Kent Bradshaw and me for this fun-filled …
Continue reading Upcoming Events Featuring the Latest Biml Products!
It’s Biml Release Day!
The months of anticipation and waiting are over, the new and updated Biml products are here! Woo hoo! BimlExpress BimlExpress is still a free SQL Server Data Tools (SSDT) plugin. As BimlHero Cathrine Wilhelmsen points out in her post titled New Release: BimlExpress 2017!: “The new installer is a lightweight VSIX (Visual Studio Extension) Installer.” The …
Continue reading It’s Biml Release Day!
Expert SSIS Training Online with Brent Ozar Unlimited!
I’ve been Brent-ified! I’m honored to announce Brent Ozar Unlimited and I are partnering to bring you instructor-led Expert SSIS Training 11-12 Sep 2017. Abstract Data integration is the foundation of data science, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals responsible for developing, …
Continue reading Expert SSIS Training Online with Brent Ozar Unlimited!