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.
I’ve recently been spending a decent amount of time helping a couple of different clients work on setting up and managing SQL Server AlwaysOn Availability Groups. In my experience, while AlwaysOn Availability Groups are a powerful solution...
It’s always a bit hard to define what exactly constitutes a bug.
In this case, I’ll argue that if/when Microsoft says that you shouldn’t USE a particular feature—and then its tooling USES that feature (by default—and in the exact wrong configu...
This post is primarily a reminder that SQL Server is very expensive to license. Which, in turn, means that smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. In this post I’ll cover two ideas...
I’ve complained in the past about how SQL Server 2008 R2 and SQL Server 2012 artificially constrained SQL Server Standard Edition to a mere 64 GB of RAM (and a total of 16 cores). SQL Server 2014 happily raises that artificial constraint to...
As humans (and especially as IT professionals), we're wired towards optimization and the need to refine. Or, as Antoine de Saint Exupéry said in The Little Prince, "It seems that perfection is attained not when there is nothing...
Author's Note: In my IT/Dev Connections Online session on "Stored Procedures: Why They're Still Relevant (and What You Need to Know to Use Them Efficiently)," I mentioned a few links and other follow-up resources that I’d...
In some ways, this post outlines a bit of what I’d call a poor man’s approach to getting copies of your backups off-box and to a secondary (or tertiary/etc.) location. And that’s because there are lots of great ways to do this in most cases, ra...
Most DBAs are aware that they can simply right click on a SQL Server Agent Job from within the SQL Server Management Studio GUI and start the job at any time desired by using the Start Job at Step menu command:
But, when you do that, you’re ...