For a while, I have been unhappy with my blog. I don’t know if it’s just me being picky or what. I have gone back and looked at some of the posts, and I am very disappointed in myself for “creating” such … drivel. Anyway, that’s not the focus of this post. One of the bigger things I have been
The last year has been full of incredible changes. I was hopeful 2021 would get off to a better start than 2020, but alas, that doesn’t seem to the case. So many things have changed in the last year, it’s almost impossible to keep track of them all. Changes Just some of the things I have experienced in the last
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 been working on. For the last day I kept running into the following error: “The remoter
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, I’m not some kind of weirdo interwebs creeper
Automatic seeding is to be the lynchpin on PowerShell script I’m working on and will post about later. The idea will be to check for new databases added during the day, and then programmatically added them to the secondary later in the day. But that post is for another day. After the upgrade, I performed a failover test, verified everything
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 fuel. The downside is, since moving in 2017, I
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. We also use Ola’s backup scripts,
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 module, makes some of the most aggravating parts of a DBA’s job so
Kids, it’s 2020. That means it is way past time to stop kicking 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 (cloud). That means we have encountered problems and we have ignored problems, and
“The Only Thing That Is Constant Is Change ” – Heraclitus The rate of change is always about the same, as fast as possible, but the directions have shifted back on themselves. Twenty years ago, when I was starting out in IT, the focus was to move off the centralized computing platform with terminal interfaces in favor of multiple servers