Month: October 2019

T-SQL Tuesday #119 – Changing My Mind

~ Jeff Iannucci ~ Leave a comment

This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on the subject. I’ve read many of these but never participated this before, but when I saw that Alex Yates asked about something in our IT career that we changed our mind about I knew instantly this would be the time to jump into this pool.

Pardon me for getting all meta, but the biggest thing in my IT career that I changed my mind about was whether or not I should even HAVE an IT career.

Let me tell you a story.

Continue reading →

How I applied 13 cumulative updates in 12 minutes

~ Jeff Iannucci ~ 15 Comments

Twitter is a strange place. I mean, aside from all the outrage practice and animal videos.

Last week I sent out a tweet about how I used dbatools to update apply cumulative updates to 13 SQL Server instance in 12 minutes. It got nine retweets and over 40 likes. Now, 40 likes in the grand scheme isn’t much, but for a guy like me with a handful of followers – it certainly gets your attention.

In one of the replies I was asked to put a post together about how I did such a thing (the updates, not the tweet), so here we are. If you’ve never used PowerShell, this might be where you could start. It’s absurdly simple. I mean, it was only five lines in PowerShell, and you could easily do it in less than that.

Continue reading →