When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have to explain the three recovery models and what they are used for. Simple, Full, and Bulk-Logged. The recovery model that you select will determine how transaction […]
Category: SQL Tuning
Are You Protected from Ransomware
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read about could have been easily prevented, while a few were much more sophisticated in nature. What are some steps that you or your organization can take […]
SQL Server Patching
Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates often contain security updates that address vulnerabilities in additional to performance and reliability improvements to SQL Server. There are also bug fixes that are often included […]
Why Aren’t You Monitoring SQL Server
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have a baseline or know what normal looks like, then how can you quantify what isn’t normal when a user starts complaining of performance issues. For SQL […]
Stop Using Balanced Power with SQL Server
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy by scaling the processor performance based on current CPU utilization, however it isn’t conducive to SQL Server workloads. For SQL Server, I always ask organizations to […]
Reasons Why SQL Servers Don’t Get Configured to Industry Best Practices
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers with straight defaults and others with various industry accepted best practices applied. One of my favorite sessions I present is “Common SQL Server Mistakes and How […]
Microsoft SQL Server Management Studio Error
I came across an issue with SSMS not loading properly recently. Regardless of launching from the start menu with or without administrator, SSMS would error out. Due to this error, I also could not uninstall SSMS to try a repair. After much trial and error and Google/Bing searches I was able to correct the issue […]
SSRS Management for the DBA
Things a DBA should know about SSRS