Error: SQL Replication – Remote Server does not exist, or not designated
Here's a quick post to remind myself and others, to check ALL of the permissions when working with replication. For the past couple of days, I've been working on getting transactional replication set up between a couple of servers in between other projects I've...
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,...
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....
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...
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....
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...
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...
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...
Garland MacNeill
DBA
Garland is a husband, father, DBA, hiker, camper, motorcyclist, and just some guy living deep in the woods.
