by Mike Walsh | Jun 10, 2017 | SQL Server DBA, Straight Up SQL Server Tips, Syndicate
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...
by Mike Walsh | Feb 8, 2017 | Straight Up SQL Server Tips
In this Straight Up SQL Server Tips series, we’re going back to basics. 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 we’re talking a bit...
by Mike Walsh | Feb 4, 2017 | Straight Up SQL Server Tips
“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...
by Mike Walsh | Jan 30, 2017 | Straight Up SQL Server Tips, Syndicate
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...
by Mike Walsh | Jan 24, 2017 | Straight Up SQL Server Tips, Syndicate
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...
by Mike Walsh | Jan 17, 2017 | Best Practices, Straight Up SQL Server Tips, Syndicate
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...