Install and Configure SQL Server 2019 Developer Edition

This post is for people interested in setting up an instance of SQL Server 2019 Developer Edition for personal use. I caution those interested in configuring an instance of SQL Server 2019 for production purposes: You should not use Developer Edition because it’s not for production workloads, by design (and according to the EULA). In …
Continue reading Install and Configure SQL Server 2019 Developer Edition

Download SQL Server 2019 Developer Edition

This post is for people interested in setting up an instance of SQL Server 2019 Developer Edition for personal use. If you are interested in configuring an instance of SQL Server 2019 for production purposes, you should not use Developer Edition – it’s not for production workloads, by design (and according to the EULA). SQL …
Continue reading Download SQL Server 2019 Developer Edition

One Way to Install SQL Server 2019 Developer Edition

In this series, I walk through one way to install and configure SQL Server 2019 Developer Edition. This series is not intended as guidance for production environments. This series is simply one way I install and configure SQL Server 2019 for my test and exploration environment. Download SQL Server 2019 Developer Edition Install and Configure …
Continue reading One Way to Install SQL Server 2019 Developer Edition

SQL Server Data Automation through Frameworks Book Available for Pre-Order

Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!

Data Driven Podcast: Bob Ward

Frank and I are honored to share an interview with Bob Ward (@bobwardms)! It was an awesome show – check it out! Notable Quotes On playing the “plague or pollen” game. (02:30) Regarding sportsball… (05:30) Virtual is the new norm. (06:30) Bob and Azure (07:30) Frank caught Bob in person at Microsoft Ready (08:15) On …
Continue reading Data Driven Podcast: Bob Ward

Four Questions to Ask When Hiring an Enterprise Data Consultant

It’s time to hire a consultant for your enterprise data project. That is awesome news, but a quick search for the perfect consultancy reveals a number of options (and hourly rates). What’s a CEO, CIO, CFO, VP, or Director to do? How do you choose a consultant with the right experience for your enterprise data …
Continue reading Four Questions to Ask When Hiring an Enterprise Data Consultant

Honored to Present at (Virtual) SQL Saturday Richmond (And a Cool Announcement)

17 Apr 2020 UPDATE: You can listen to Stevie Ray share about his presentation (and more) in this episode of the Data Driven Podcast: Stephen Leonard on STEM and the Frustration Inherent to Engineering. Or you can listen right here! I am honored and excited to deliver Azure DevOps and the SSIS Development Lifecycle at …
Continue reading Honored to Present at (Virtual) SQL Saturday Richmond (And a Cool Announcement)

In 2020, Two Full Training Days, Two Continents

It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents

One Way to Extract SQL Server 2017 Installation Media

In my post titled SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2 I wrote about storing the SQL Server 2017 Developer Edition installation media in a directory. But I failed to explain how I do this. This is how I store the SQL Server 2017 Developer Edition installation media …
Continue reading One Way to Extract SQL Server 2017 Installation Media

SSIS, Docker, and Windows Containers, Part 6 – Executing Packages in an SSIS Catalog in a Container

In the previous six posts I: examined how to install Docker for Windows, pull a test image, search for a SQL Server on Windows image, install and interact with it (Part 0) shared why I want to do all this (Part 1) shared one way to execute SSIS on a container in Part 2 shared …
Continue reading SSIS, Docker, and Windows Containers, Part 6 – Executing Packages in an SSIS Catalog in a Container