T-SQL Tuesday #176: What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?

July 2024’s T-SQL Tuesday is hosted by Dr. SQL himself, Louis Davidson. The topic is “What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?” I learn from my mistakes and I’ve learned plenty since my first data platform job! Defining “my …
Continue reading T-SQL Tuesday #176: What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?

SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent

I’m reading Announcing SSMS 20.2 … and getting feedback for SSMS 21 by Erin Stellato (LinkedIn) on the SQL Server Blog and this fix caught my eye: SSIS and SQL Agent – many customers ran into a connection error (“The certificate chain was issued by an authority that is not trusted”) in SQL Agent when trying …
Continue reading SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent

SSIS Extension Updates – Jun 2024

I am changing the way I report updates to the SQL Server Integration Services extension for Visual Studio. Henceforth, I intend to post an update once each quarter. I can hear some of you thinking, “Why are you making this change, Andy?” That’s an excellent question. I’m glad you asked! I get distracted and forget …
Continue reading SSIS Extension Updates – Jun 2024

New Data Factory Training Delivery Dates

I’m honored to announce new data factory training delivery dates for the summer of 2024! 24 Jun 2024: A Day of Fabric Data Factory 25 Jul 2024: A Day of Azure Data Factory 26 Jul 2024: A Day of Fabric Data Factory 20 Aug 2024: A Day of Azure Data Factory 21 Aug 2024: A …
Continue reading New Data Factory Training Delivery Dates

T-SQL Tuesday #175: Old Tech, New Tech, Bold Tech, Blue Tech

Update: Check out the T-SQL Tuesday #175 Roundup! Microsoft Build 2024 was just last month (at the time of this writing) and the sheer number of announcements is almost overwhelming! You can read about the announcements from the Build Book of News and view selected sessions online. I am honored to host this month’s T-SQL …
Continue reading T-SQL Tuesday #175: Old Tech, New Tech, Bold Tech, Blue Tech

Update on the John Barker Mentoring Project

In December I announced The John Barker Mentoring Project: “I am committing to mentor young people who live in the south-central Virginia area.” I have three mentees with whom I meet online or in-person (hence the south-central Virginia requirement) about every two weeks. They’re at different places in their lives and careers, from just getting …
Continue reading Update on the John Barker Mentoring Project

One Way to Invoke Fabric Data Factory Pipelines Using the Fabric REST API

I’m an automation weenie, that’s a fact. It’s why I’m drawn to frameworks – especially data engineering execution orchestration frameworks. Speaking of frameworks, if you haven’t checked out Martin Schoombee’s series titled Building a Framework for Orchestration in Azure Data Factory: A Series, you are missing out. First, Martin is scary smart. Second, he shares practical …
Continue reading One Way to Invoke Fabric Data Factory Pipelines Using the Fabric REST API

Some Frank Thoughts About Newsletters

“We need to talk.” Actually, we don’t need to talk, but I would like to share some thoughts about newsletters and managing privacy, especially the privacy of email addresses. I Encourage You to Unsubscribe I can hear some of you thinking, “Wait, Andy. You send out newsletters and you’re encouraging your readers to unsubscribe?” Yep. I’m only …
Continue reading Some Frank Thoughts About Newsletters

Announcing Data Engineering Fridays!

I’m excited to announce Data Engineering Fridays! I can hear some of you thinking, … “What are Data Engineering Fridays, Andy?” That’s an awesome question! I’m glad you asked. Data Engineering Fridays is a weekly stream, between 24 May and 23 Aug 2024, in which I lead a discussion about data engineering-related topics. The 24 …
Continue reading Announcing Data Engineering Fridays!