I’m honored to announce Expert SSIS – a course from Enterprise Data & Analytics! The next delivery is 01-02 Apr 2019, 9:00 AM – 4:30 PM ET. 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 …
Continue reading Join me For Expert SSIS Training!
Category:Biml
Biml, Book Reviews, and Metadata-Driven Frameworks
I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks
Stairway to Biml 9 is Live!
I am pleased to share Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework is now live at SQL Server Central! Typing that, I realize I neglected to publicize the fact that two other Stairway to Biml articles were recently published at SQL Server Central: Stairway to Biml Level 7 – Populating the Database for …
Continue reading Stairway to Biml 9 is Live!
“Do I Need a Biml Framework, Andy?”
No. No, you do not need a Biml Framework. In the same way that I do not need a vehicle powered by an internal combustion engine, you do not need a Biml framework. You see, I live about 5 miles from Farmville Virginia. I could walk to town each time my family needs groceries. I could pack as many …
Continue reading “Do I Need a Biml Framework, Andy?”
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
PASS Summit 2018 Starts in 10 Weeks!
Can you believe the PASS Summit 2018 begins only 10 weeks from today (27 Aug 2018)? I confess, this is sneaking up on me fast! I will be there. Will you? Where Can You Find Andy at the PASS Summit 2018? Precon! Monday 5 Nov 2018, I’m delivering a full-day pre-conference session titled Intelligent Data …
Continue reading PASS Summit 2018 Starts in 10 Weeks!
Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
Join me 30 Aug 2018 at noon EDT for another free webinar titled Use Biml to Build a Local Copy of an Azure SQL DB. This webinar is inspired by a social media post by a friend. His company is using Azure SQL DB in Production. They want to make a copy of the Production …
Continue reading Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
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
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
One Learning Path for Biml
I regularly get email asking how to learn Business Intelligence Markup Language (Biml). I thought I would share one Biml learning path in this post. Learning Biml is like learning any new technology: it’s hard. You have to commit to spending hours “heads down” working through examples, viewing training material, and reading blogs and books. …
Continue reading One Learning Path for Biml