Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Depending upon some of the SQL Server Agent Jobs being run by a SQL Server Agent, it's possible for the SQL Server Agent to need elevated permissions to run some of the tasks it's trying to tackle. This can be the case in situations where repli...
I’m guessing I’m not the first person to come up with the need to try and correlate a problem or issue on a server against whether or not a SQL Server Agent job was running or not. Only when I recently did a Google search to see if there were a...
The primary video card in my (awesome) workstation sadly died earlier this month.
Which meant that rather than fiddle around with trying to get old drivers to uninstall correctly and new drivers to install optimally with my new/replacement v...
NoSQL and I don't get along.
That's not really NoSQL's fault. Nor, frankly, is it mine.
Instead, I blame our rocky relationship on NoSQL's fan club—or developers who blindly assume that NoSQL is the answer to all of the world's problems. It'...
Maybe I’m just getting old, but I’m personally fairly tired of April Fools' Day or, at least, how it gets handled in the technical world. After getting burned a few times (years ago) by forgetting that it was April Fools' Day, I’m now to the po...
I'm hesitant to call this a trick—simply because there's nothing special to it (i.e., it's taking advantage of known/existing editing functionality from within SQL Server Management Studio, or SSMS)—and because I assume most people should know ...
In previous posts, I outlined reasons to avoid in-place upgrades of SQL Server, along with detailed migration steps and guidelines for demoting your old server and promoting a new server as part of a 'side by side' migration. In both posts th...
Part I: Detailed Migration Steps for SQL Server Upgrades
Part II: Detailed Migration Steps for SQL Server Upgrades
Post Migration
Assuming that everything went without a hitch (i.e., all applications are able to connect to and work agai...
Preparation / Seeding Databases for Migration
The key to minimizing downtime during migrations is to use a technique that's roughly akin to poor man's log shipping—where you spin up a restored (but non-recovered) copy of your produc...