One Way to Create a Parquet File from SQL Server Data

Yesterday I was coding away, deep into using C# to decompress and parse Excel XML so I could read data from a specific worksheet in a workbook on a server without Excel objects installed, when I saw the following on Twitter: For those of you who do not already know… I Don’t Switch Contexts Well I …
Continue reading One Way to Create a Parquet File from SQL Server Data

Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

Things change. Things change in software. Things change regularly in software. If you take nothing else away from this post, please take those nuggets of wisdom. Last week, my latest book – titled Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, (Second Edition) was …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

New DataDriven Episode with Peter Voss

 In this episode of Data Driven, Frank and Andy speak with Peter Voss about Artificial General Intelligence, Personalizing Personal Assistants, and Motorcycles Sponsor Sponsor: Audible.com – Get a free audio book and support DataDriven – visit thedatadrivenbook.com! Guest Bio Peter Voss is the world’s foremost authority in Artificial General Intelligence. His company Aigo (https://www.aigo.ai/) has created the …
Continue reading New DataDriven Episode with Peter Voss

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