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!
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
SSIS Framework Community Edition Updates
SSIS Framework Community Edition – the free and open-source SSIS Catalog-integrated execution framework – has been updated! The code now includes: A script to set a Catalog Literal override configuring the Parent package’s SSISDB connection manager with the connection string for your target SSISDB database. A stored procedure called custom.execute_catalog_parent_package that will simplify Framework Application executions …
Continue reading SSIS Framework Community Edition Updates
*DataPoint* SQL Saturday Atlanta Round-Up
Stevie Ray and I had a great time visiting Atlanta for SQL Saturday 652! Kudos to Rie Irish, the leadership team, volunteers, speakers, sponsors, and attendees – it was an awesome event! I was honored to spend a few moments with some cool technologists. First up were Adam Saxton and Patrick LeBlanc of Guy in …
Continue reading *DataPoint* SQL Saturday Atlanta Round-Up
*DataPoint* Denny Cherry on the Rise of Data Science
Frank caught up with Denny Cherry at #MSInspire2017 for a chat about the Rise of Data Science.
The #MSInspire DataViz Wall
Frank is hanging out at the Microsoft Inspire 2017 DataViz Wall! Want more Data Driven videos? Connect with us on Facebook! :{>
Frank at Microsoft Inspire 2017 – Day 2
If Dr. Kristin Tolle – Director of the Data Science Initiative in Microsoft Research Outreach – says Frank is a data scientist, then Frank is a data scientist. Check out the Microsoft Learn Analytics site Kristin mentioned, as well as the Microsoft Certified Data Science certification program Frank just completed! Frank is having an awesome …
Continue reading Frank at Microsoft Inspire 2017 – Day 2
New Data Driven Episode: Kamal Hathi
This week Frank and Andy are joined by Kamal Hithi, General Manager at Microsoft, co-founder of Microsoft’s multi-billion dollar Analytics and Business Intelligence products, team leader for the team that is responsible for the end-to-end strategy, design and engineering of Power BI!
Building Custom Tasks for SQL Server Integration Services Is Now Available!
Building Custom Tasks for SQL Server Integration Services, my latest book, is now available! Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on …
Continue reading Building Custom Tasks for SQL Server Integration Services Is Now Available!
New Data Driven Podcast: Darren Lacy
Frank and I had a lot of fun interviewing Darren Lacy for the Data Driven podcast! Check out the show titled Darren Lacy on Making the Jump to Data Science from BI and Disneyland for Geeks! Check out past Data Points and Data Science Daily episodes! Become a Data Driver (join our mailing list)! :{>
Enterprise Data & Analytics is Sponsoring SQL Saturday Atlanta!
Enterprise Data & Analytics is proud to sponsor SQL Saturday 652 – Atlanta 15 Jul 2017! And I am honored to present Designing an SSIS Framework. Abstract Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building …
Continue reading Enterprise Data & Analytics is Sponsoring SQL Saturday Atlanta!