Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

Update: Please be sure to read Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9 for important updates to the demo code. I am honored, humbled, and excited to announce the release of Building Custom Tasks for SQL Server Integration Services, 2nd Edition! In the first edition of this book, the demo task is …
Continue reading Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

Data Minute and Links for 09 Feb 2021

Here’s the Data Minute and Links for 05 Feb 2021, followed by links. Enjoy! Links My friend Aaron Nelson (@SqlVariant on Twitter) share a post titled Query DB2 From PowerShell. If you administer SQL Server, you should check out DbaTools! Today’s sponsor is me and my post titled Source-Control SSIS Catalog Contents in Azure-DevOps. It’s …
Continue reading Data Minute and Links for 09 Feb 2021

Data Minute for 08 Feb 2021

Here’s the Data Minute and Links for 08 Feb 2021, followed by links. Enjoy! Links Peter Voss was our latest guest on DataDriven. A former guest, Brent Ozar, wrote an interesting post about SQL Server Partitioned Tables. Today is Frank‘s birthday! Today’s sponsor is SSIS Framework Community Edition. Learn more about SSIS Framework Manager CE …
Continue reading Data Minute for 08 Feb 2021

Data Minute and Links for 05 Feb 2021

Here’s the Data Minute and Links for 05 Feb 2021, followed by links. Enjoy! Links IBM quantum computers are speeding thing up quite a bit! Microsoft Azure Quantum in now generally available (GA). Today’s sponsor is Impact Quantum – a podcast dedicated to Quantum Computing! Check out Frank’s podcast on Azure Quantum. Learn more about …
Continue reading Data Minute and Links for 05 Feb 2021

Data Minute and Links for 04 Feb 2021

Here’s the Data Minute and Links for 04 Feb 2021, followed by links. Enjoy! Links From Frank’s World: How Anastasia Marchenkova Became A Quantum Computing Researcher I am a self-described “weather geek.” (Take a look at AndyWeather.com if you doubt it!) Check out these weather-related datasets available for free at the NOAA Climate.gov Dataset Gallery. …
Continue reading Data Minute and Links for 04 Feb 2021

SSIS Framework Manager CE Version 0.3 is Available

I made a few more changes to SSIS Framework Manager CE (Community Edition). The latest change is to add fields to specify the Database and Schema names. A customer shared that their enterprise considers the SSIS Catalog database – SSISDB – a system database (which I totally understand). At their request, I built a new collection of …
Continue reading SSIS Framework Manager CE Version 0.3 is Available

Data Minute and Links for 03 Feb 2021

I’ve experienced an issue with Restream.io not recording my screen for the past couple days. I’m on the horn with Restream Technical Support as I type, and I am certain they will get it resolved quickly because Restream is awesome. The bug means I needed to reshoot (yay…not really…) the screen and edit the video. …
Continue reading Data Minute and Links for 03 Feb 2021

Data Minute Links for 02 Feb 2021

Links for today’s Data Minute: Companies will battle for boomers Is Azure Synapse Analytics Ready for Production? Data Minute Today’s Sponsor: Enterprise Data & Analytics Are you interested in sponsoring a Data Minute? Contact me! I welcome your feedback and suggestions for Data Minute. :{> Need Help With Your Enterprise Data Warehouse or ETL? At …
Continue reading Data Minute Links for 02 Feb 2021

Updates to the SSIS Extension for Visual Studio 2019

On 25 Jan 2021, the Microsoft SSIS Team released version 3.12 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning that users rollback to v 3.11.1. The warning was issued 31 Jan 2021 and reads: …
Continue reading Updates to the SSIS Extension for Visual Studio 2019