SSIS in SSMS Version 18

Version 18 of SQL Server Management Studio (SSMS) has been out for a few weeks now, but I just now had the opportunity to install it and tinker. There are a lot of new features! Here’s a list of SSIS-related features: Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are …
Continue reading SSIS in SSMS Version 18

Free Webinar: Build and Load a Staging Database with Biml

The next free webinar from Enterprise Data & Analytics is titled Build and Load a Staging Database with Biml – happening 29 May 2019 at 12:00 PM EDT. Abstract Watch Andy Leonard, Microsoft Data Platform MVP and BimlHero, create a Biml solution that would build and load a staging database using Biml with minimal configuration. …
Continue reading Free Webinar: Build and Load a Staging Database with Biml

The Recording for “A Data Science Story” by Shannon Lowder is Available

Shannon Lowder (@shannonlowder | shannonlowder.com) did a fantastic job presenting the true story of a data science project. He presented the problem he was trying to solve, the places he looked for data, issues and obstacles he encountered, and solutions he developed. Enjoy! Links Storm Events files NOAA Hail Data files Microsoft Azure Machine Learning: …
Continue reading The Recording for “A Data Science Story” by Shannon Lowder is Available

Azure-SSIS Starts Faster

I had the honor to deliver “Moving Data with Azure Data Factory at SQL Saturday – Atlanta this weekend. Because Azure changes daily, I fired up an Azure-SSIS instance Integration Runtime the morning of my presentation and walked through my demo. I play a game I call, “What’s Changed in Azure!” It’s a fun game. …
Continue reading Azure-SSIS Starts Faster

SSIS Script Task Error

Has this ever happened to you? You’re tooling along building an SSIS package. You configure a Script Task, press the F5 key, and BAM! Error! DTS Script Task has encountered an exception in user code:Project name: ST_… Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean …
Continue reading SSIS Script Task Error

Anders Schneiderman on Changing the World

Earlier this year, Frank (@Tableteer) and I had the honor of interviewing Anders Schneiderman (LinkedIn) on Data Driven. The episode is now live and titled Anders Schneiderman on Why We Need to Prepare Communities for the Future of Work. Anders has a plan to help people leverage emerging technology to transform their destiny. Anders’ plan …
Continue reading Anders Schneiderman on Changing the World

Free Webinar: A Data Science Story

From Shannon Lowder, Data Scientist, BimlHero: “You’ve all heard about data scientists, and seen job postings for them. But what is the job like, really? “Let me share the story of my first official data science project. While sharing the story I’ll stop to point out the skills used that many DBAs, PowerShell junkies, BI …
Continue reading Free Webinar: A Data Science Story

Free Webinar: Is Power BI Right for You?

Join us for “Is Power BI Right for You?” 15 May at 12:00 PM EDT! Join Pluralsight course author Eugene Meidinger (@SQLGene | sqlgene.com) as he demonstrates problems Power BI is designed to solve. This free webinar includes comparisons between Power BI and popular reporting platforms (SSRS, Tableau) and a high-level introduction to Power BI …
Continue reading Free Webinar: Is Power BI Right for You?