“Ex-Admin Deletes All Customer Data and Wipes Servers”
June 11, 2017
My headline is borrowed from a headline on bleepingcomputer.com. This just happened to a Dutch hosting provider in 2017. You can read the article. Actually, you must read the article. If you didn’t here’s the basic gist: An administrator quits or was fired or whatever. He or she didn’t get their access terminated right away. He
Hey Techies – Get Out of Debt
June 2, 2017
How do you eat an elephant? I’ll tell you at the end if you don’t already know. In the meantime let’s talk about another elephant – the one in the room – you are in debt. In some way, you’re probably in debt right now. Maybe you owe to student loan or credit card companies.
SQL Server Max Memory Best Practices
February 8, 2017
In this Straight Up SQL Server Tips series, we’re going back to basics, focusing in on SQL Server memory, specifically talking about setting SQL Server MAX memory. Many of these are findings in our SQL Server Health Checks or things I bump into on the forums and Q&A sites when I’m out answering questions. Today
How To Manage The SQL Server Transaction Log File
February 5, 2017
“Help! My SQL Server transaction log file has run out of space on my SQL Server!”, “Why is my SQL Server Log file so big?”, “How do I shrink my SQL LDF?” – I hear these questions all the time. I’ve been blogging since 2009 and way back then I wrote some posts about shrinking,
Optimize For Ad Hoc Workloads – Enable or not?
January 30, 2017
With today’s Straight Up SQL Server tip, I want to talk about a setting I have so far only ever recommended to enable: Optimize for Ad Hoc Workloads. Rather than just make a suggestion, I want to keep in the spirit of the tips for beginner approach to the series and describe a little of
SQL Server Corruption – Read Before it Happens
January 24, 2017
SQL Server Corruption is a rather complex topic. As a consultant, I’ve been called in many times to help a client suffering from SQL Server corruption in some form or another. As a forum post answerer I’ve helped some pretty sad situations and tried to help. There have been times when I’ve reached out to
DBA Questions To Ask Software Vendors
January 17, 2017
Do you buy software from independent software vendors? Does it run on SQL Server? Are you responsible for supporting that software? Here are some questions that you can ask a software vendor about the way they use SQL Server. It’s best to ask these questions before you are a customer, too; you’ll have a bit
SQL Server Version Numbers – Do they matter?
January 17, 2017
It’s a trick question, yes. Your SQL Server version matters! In this post I’ll tell you how to check your version, talk about what makes up the version number and talk about why it matters so much and why you should get a plan in place to regularly upgrade or update SQL Server. This post is part of
Introducing Straight Up SQL Server Tips
January 16, 2017
An Introduction and a Why. . . I’ve been blogging about SQL Server since 2009. Over the years I’ve blogged about many topics and levels. For some reason, I’ve most loved writing the posts to beginner and intermediate levels though. Things that trip folks up day to day, etc. While I’ve been an independent consultant
Remote DBA Benefits – After Hours Support
November 23, 2016
2016 has proven to be a busy year for Straight Path! We launched our DBA On Demand  Service. This is a Senior level Remote DBA offering – the basic premise being “what if you had access to world class Senior level talent, and paid for only what you needed from them?”. We’ve on boarded several