Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time moving data in this direction, so we had some extra work to do. After installing the SSIS package and the MySQL .NET connector in the development…

Read More Write It Down!

This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed & his team did a terrific job with organizing it. Communication for both attendees and speakers was excellent, and as far as I can tell, everything…

Read More Recapping SQL Saturday Albany 2020 (virtual)

A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to take the next step, determining which updates need to be downloaded? That’s exactly what Josh asked on the SQL Community Slack recently. Can Test-DbaBuild also bring…

Read More Finding & Downloading Required SQL Server Updates

It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild from the dbatools PowerShell module. But the result was always the same – it never returned a Service Pack or Cumulative Update target. I glossed over…

Read More Checking for SQL Server Updates with dbatools