SSIS in SQL Server 2022 CTP 2.0

SQL Server 2022 Community Technology Preview 2.0 is available, and it includes the SSIS Catalog! Create an SSIS Catalog At the time of this writing, the SSIS 2022 Catalog is similar (identical, perhaps) to the SSIS 2019 Catalog. Connect to a SQL Server 2022 instance using SSMS and right-click the Integration Services Catalogs node in …
Continue reading SSIS in SQL Server 2022 CTP 2.0

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

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