I’m honored to announce I am delivering A Day of Fabric Data Factory – a full-day of in-person pre-conference training at SQL Saturday Pittsburgh! The precon happens Friday, 11 Oct 2024; SQL Saturday Pittsburgh is Saturday, 12 Oct 2024. Abstract Do you want to learn more about cloud data integration using Fabric Data Factory? Is …
Continue reading Presenting A Day of Fabric Data Factory at SQL Saturday Pittsburgh
Announcing SSIS Premium Training
I’m excited to announce the availability of SSIS Premium, a training offering focused solely on SQL Server Integration Services (SSIS) recorded training. Learn more about each offered course at the following links: From Zero to SSIS – four days of recorded training, includes labs. Master the SSIS Catalog – a day of SSIS Catalog recorded …
Continue reading Announcing SSIS Premium Training
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
T-SQL Tuesday #175 Roundup
It’s time to celebrate and confess. I was honored to host the June 2024 edition of T-SQL Tuesday – #175! That’s the celebration. Confession: I had GoDaddy add a firewall back in February and it worked well. Too well, in fact! A friend reached out to let me know comments on the blog post – …
Continue reading T-SQL Tuesday #175 Roundup
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