This month I am providing a 12-point checklist of scripts to check your SQL server’s current security posture. Use these scripts to get an idea of where you are, so that you can make plans for the places you may want to go. The paradigms of least privilege and defense in depth are important to … Read more
Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best practices and monitor server health across over 20 environments. This post condenses the tools that can help and the configurations that are most likely to cause … Read more
It’s day four of the two weeks to a healthier SQL Server series. If I were making this ten-day plan even just three years ago, I would have had this lower on the list. With the security and compliance needs of the world today and the way Microsoft services SQL Server – it’s important to … Read more
It’s 5 AM on Wednesday. Your CIO has called your cell phone at home. “We need you to log in right now! Someone or something deleted all of the inventory. I tried to help out the team right before the inventory disappeared, and I was running some SQL commands I found and a couple of … Read more
I almost didn’t get to write this post tonight about a lesson from my farm life for us DBAs. I could have been dealing with a massive headache or a hurt daughter – or worse. But. I get to write it so that you can learn from our near incident… First A Question How are … Read more
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 … Read more
When we do a SQL Server Health Assessment, we quickly dive into SQL Server performance and Windows/Physical/Virtual resource usage counters. During our kick off interview we always ask if you have a SQL Server baseline from the past to compare. Usually the answer is no, unfortunately. Like monitoring and alerting, many of the tools vendors make automated baseline collection tools. Also like alerting, though, … Read more