Our first quiz on best practices is online now. Quiz #1 is about SQL Server Configuration. How will you do?
Month: August 2017
Pay Yourself First
I’ve done a ton of interviewing in my career, both as the interviewee, and as the interviewer. The biggest problem I see is the huge number of DBAs who have let themselves fall behind. How does this happen? Middle of the pack Once you’re a more or less established DBA, you have yourself a job,…
SQLBP Monthly #1
Our inaugural newsletter hit your inboxes today. You can view it online and learn more about our featured blogger David Klee. 🆕 SQL Server Best Practices Monthly 🆕 Don’t miss out on future newsletters:
How To Not Be a Commodity DBA – Part 1
A couple of months ago I wrote about the concept of the DBA as a commodity (DBAaaC), and how it can be so easy for management to consider any DBA as a basic, and replaceable resource within their organization. This got me to thinking (and it would seem that my thinking takes a long time)…
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill up! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these sessions so they can help…
Coding Naked
I know the title sounds like clickbait, but it’s how I’ve felt for a long time. Why? Because of CASE tools. CASE stands for Computer-Aided Software Engineering. Here, I’m referring to data modeling tools like ErWin and ER/Studio. It disheartens me that the industry as a whole has gotten away
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to minimize the impact to the business. You are caught in a difficult decision. Do you repair the VM as quickly as possible, but possibly lose traces of what went wrong. In doing so, that loss of…
31 Days of Disaster Recovery Revisited
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog posts dedicated to the topic (though not 31 days in a row) have been compiled into a 75 page eBook that can be downloaded from the new website SQL Server Best Practices. Reposted with permission…
Patching SQL Server and SSMS? Order matters.
If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL Team is really rocking over at Microsoft putting out fixes and enhancements fast and furious. When CUs (cumulative updates) and SPs (service packs) come out, it makes sense to install the latest SSMS update at…
SQL Server on Linux Series: Backing up over the network
One of the challenges with any SQL Server business continuity strategy is backing up your databases and logs on a frequent basis. With Windows, we’ve known how to accomplish this for years. But, with SQL Server on Linux, you can accomplish the same task with just a few different twists. It is similar to mounting…