A couple months ago I delivered a short (15 minute) presentation at work about the importance of having a good professional network and how I’d found mine. As I was developing it, I had to keep redirecting myself as the theme would start trending towards how great the #SQLFamily is. To be fair, that’s what…
Read More New Presentation – The SQLFamilyThis 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 UpdatesJust because we aren’t all together in Houston doesn’t mean we can’t have a #SQLRun at this year’s Summit. It might even be easier for some folks as there’s no luggage space/weight limits, jet lag or a late night out on Tuesday.
Read More Virtual SQLRun for PASS Summit 2020Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place to stash intermediate results, break a dataset down into more manageable chunks, or even share them between procedures. And as it turns out, there’s more than…
Read More Three Ways to Create a Temp TableFor the second consecutive year, I will be speaking at SQL Saturday Albany 2020 on July 25th, 2020. I will be presenting “Keys to a Healthy Relationship with SQL Server” at 3:30 PM.
Read More Speaking at SQL Saturday AlbanyT-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Kenneth Fisher (blog | twitter) asks us for non-SQL tips & tricks.
Read More T-SQL Tuesday #127 – Non-SQL Tips & TricksSetting up a home office can be a daunting task. Doubly so when you don’t get an opportunity to plan it out and you have to set things up with no warning and items on hand. Since starting to work from home on March 17th, my desk has been through 3 major versions. A word…
Read More Home Office Desk EvolutionIt 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 dbatoolsWe’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at the halfway point yet. I’m preparing myself for a few more months, both mentally and in terms of my workspace. Here are a few resources that…
Read More Remote Work Resources