Do you work for a charity or non-profit organization? Submit your application today. I haven’t advertised this in the past and… I’m not sure why: I donate licenses for SSIS Catalog Compare and (non-free) SSIS Framework Editions – and subscriptions to Biml Academy and SSIS Academy – and Enterprise Data & Analytics Training – to individuals who …
Continue reading Free Stuff for People Who Give Back: Announcing 2019 Scholarships
Category:Biml Academy
Enterprise Data & Analytics and Andy Leonard Consulting
I occasionally get questions about my companies (yes, plural) so I thought I’d write a post explaining them. Enterprise Data & Analytics Enterprise Data & Analytics is a boutique consulting firm. I own the company and I also deliver consulting services. We have a team of experienced engineers who deliver everything from cloud data migrations to …
Continue reading Enterprise Data & Analytics and Andy Leonard Consulting
DevOps and SSIS and Azure Data Factory
I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source: SSIS Framework Community Edition – free, open-source, and …
Continue reading DevOps and SSIS and Azure Data Factory
Announcing SSIS Academy!
I’m pleased to announce the availability of SSIS Academy! I have a confession: Late last year when I wrote a post titled The Second-Best Time, I was writing to yours truly. I was inspired by some friends and presenters I met at the PASS Summit 2017. I jotted down some notes – just like I …
Continue reading Announcing SSIS Academy!
Biml Academy – Using Biml to Build a Target Database
Using Biml to Build a Target Database is the latest unit available at Biml Academy. You can see a description of Using Biml to Build a Target Database at the link above, but I ask you to consider Basic Biml Training – which includes: Using Biml to Build a Target Database Adding Your First BimlScript Build …
Continue reading Biml Academy – Using Biml to Build a Target Database
Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
My friend and brother, Patrick LeBlanc (@patrickdba), built a cool Power Bi Dashboard (and database!) to help K12 education systems track students and student activities such as attendance. Better yet, he gives it away! He gives away the code and he shares a free Guy in a Cube video walking through the features. Patrick emailed and …
Continue reading Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
Website Ch-ch-changes…
Inspired by Frank La Vigne’s (blog | @Tableteer) snappy update to the Data Driven home page, I decided to spruce up a couple / three of my websites including this one, andyleonard.blog. I added the sidebar shown on the right of the site. It contains a more-readily-available search box and links to other websites I maintain – …
Continue reading Website Ch-ch-changes…
Biml Academy Relaunch! (Well, beta…)
I’m no Brent Ozar but after tens of hours (and tens of dollars – and a little help and some great advice from Brent), I’ve managed to get Biml Academy relaunched as a training site! First, the free content that’s always been at Biml Academy will always be there. The links have changed because MeetingBurner is shutting …
Continue reading Biml Academy Relaunch! (Well, beta…)
Announcing Biml Academy v2.0
Update: See this post at Biml Academy for an opportunity to sign up for 50% off! I am pleased to announce the relaunch of Biml Academy! The site currently hosts free training from the very first Biml Academy week – way back in the Spring of 2016. I delivered that training while on the road. …
Continue reading Announcing Biml Academy v2.0
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. :{>