Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
There's a saying that all warning labels in airplane cockpits are written in blood (meaning that warnings stem from an unfortunate accident or mistake someone else made in the past—which shouldn't be repeated). To that end, I've decided to po...
As a consultant, one of the things I commonly do is help organizations upgrade to newer editions of SQL Server. When doing so, I never recommend in-place upgrades for production servers. Instead, I always recommend standing up brand new servers...
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above...
Every once in a while I get a question from either clients or from folks who’ve attended one of my presentations about just exactly what it is that DBAs should be doing day-to-day.
As I intimated at in my previous post on the importance of cle...
I recently received an email asking whether I had a formal listing of roles and responsibilities for what a DBA does in a larger data center. (In the end the person asking for this information was really just looking for a general overview&mdash...
I’ve blogged twice about a serious flaw with SQL Server security on Internet-facing (or accessible) SQL Servers running with SQL Server Authentication Enabled:
In my first post, Staying Safe from the Coming Storm, I outlined how SQL Server...
Kalen Delaney and I go back over a decade. Only, she doesn’t know that.
In 2000—after teaching myself *cough* Access *cough* and then teaching myself some very rudimentary aspects of SQL Server—I interviewed for a job a MyComputer.com [1]. As ...
Last year I blogged about Devolutions’ Remote Desktop Manager—an exceptionally useful, valuable, and well-managed product that I decided to call it my Favorite Tool of 2012. I still love Remote Desktop Manager, constantly extol its virtues to a...
In the past month or two I’ve bumped into a couple of new clients with individual servers that have each been running for over 100 days. That’s pretty impressive in terms of what it means for overall uptime. Only, while it is cool to see a SQL ...
Roughly a year ago, I posted (a rather lengthy) overview of the rationale and reasoning behind my preference to avoid putting anti-virus on SQL Server (or any other production server) whenever possible. In that post, I also listed some ways to ...