Kent Bradshaw and I are excited to announce the availability of SSIS Catalog Browser v0.9.20! SSIS Catalog Browser is free and surfaces SSIS Catalog projects and configurations metadata in a single unified view. The latest version fixed a handful of bugs, improved load query efficiency, and fixed duplication and misplacement of reference mappings in project and …
Continue reading Announcing SSIS Catalog Browser v0.9.20
Potential Danger Using Deploy Package with SSIS 2016
I… tweeted? X’d?… this message 11 Jul 2024. As promised, here’s the public post. If you want to skip some history mixed with the description of EDNA’s SSIS framework, feel free to go to the section labeled “Imagine My Surprise…” Some Back Story I have a long and storied history with frameworks. My ETL frameworks …
Continue reading Potential Danger Using Deploy Package with SSIS 2016
Presenting A Day of Fabric Data Factory at SQL Saturday Pittsburgh
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