TGIF: It’s been one of those weeks

TGIF: It’s been one of those weeks

  Today, I’m not thankful that it’s Friday, although I am happy about it. Today I am thankful for the wisdom of Grant Fritchey ( b/t ). No Grant didn’t help me with any kind of problem, at least directly. Hell, I have never even met the man in person anyway. No,...

read more

Be Wary of Windows Firewall

I ran into an issue last week when I was working on upgrading a SQL2014 Availability Group to SQL2019. Nothing went wrong with the actual SQL upgrade, however, post-upgrade I ran into some headaches. Turns out Windows Firewall can bite you in the ass on an upgrade....

read more

Adjusting to Working from Home

As a DBA, working from home (WFH) is not a new concept or new experience, I do it a lot. However, this shift to working from home due to the office being closed for Covid-19 is a little different. First off, I'm enjoying getting my commute time and saving money on...

read more

Restore to a point in time

This week I had to restore to a point in time for an entire instance. The instance had approx 25 databases on it, and all of them had to be replaced to get the information we needed. As this was on a SQL Availability Group, we are backing up the logs every 15 minutes....

read more

DBATools

I don't know why I am slow to take up new tools, but I am. I recently, like back in December, began working with DBATools. In case you're not familiar, DBATools is a PowerShell module assembled by the community over at DBATools.io. This module, oh this wonderful...

read more

Just fix it

Kids, it's 2020. That it means it way past the time to kick the can down the road. Most of us in IT have been around long enough to see us shift from a centralized CPU (mainframes) to decentralized (client/server) architectures back to a centralized approach again...

read more

New Decade, More Change

“The Only Thing That Is Constant Is Change ” - Heraclitus A long way back, a Greek philosopher said something about change being the only constant. The guy was right, but he would have made a horrible IT project manager. It's a true statement, but at the same time...

read more
Garland MacNeill

Garland MacNeill

DBA

Garland is a husband, father, DBA, hiker, camper, motorcyclist, and just some guy living deep in the woods. 

Archives