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.
As part of my 5 Common Gotchas with SQL Server AlwaysOn presentation that I recently gave, I mentioned that I’d provide a links and additional resources as a follow up. (And for anyone who didn’t attend but would like to, that link...
SQL Injection in the News
As far as I’m concerned we’ll likely always have SQL injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to a...
Two caveats: First, this post is NOT about what you think it is. Second, I have a laughably low tolerance for most medications/drugs.
A Story of Diminishing Performance and Overall Sluggishness
For the past few weeks I've just felt r...
"A good plan violently executed now is better than a perfect plan executed next week."—George S. Patton
Baselines and subsequent comparison metrics make it easy to determine whether index modifications and code changes are truly improving the ...
Two years ago I blogged about a substantial, known, problem with SQL Server Authentication. As a recap, some of the key highlights covered in that post were:
SQL Server Authentication (i.e., username and password checks handled by ...
A maintenance task that many 'reluctant DBAs' commonly overlook is the need to keep historical information in the msdb database trimmed, or 'truncated' on a semi-regular basis. Otherwise, it IS possible for so much data to get 'crammed' into th...
I've long held little respect for technical certifications. Part of that respect has always stemmed from how too many technical certifications tend to revolve around cramming, boot-camps, brain-dumps and a number of other techniques and tric...
In the past few months I've provided a number of blog posts about ways to configure and use SQL Server's Database Mail functionality to proactively send alerts and notifications. However, one way that I've recently found to be more effective...
As with most SQL Server best practices, this one comes with a few caveats—in that it might not be the best option in all environments or scenarios. But, for most servers deployed in most SMBs—especially where a few users might have the abili...