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 […]
Category: Tibits
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 […]
SSRS Management for the DBA
Things a DBA should know about SSRS
How to Reset the SA Password When Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved from one domain to another without the domain being trusted or having a local SQL admin account. I recently encountered another incident where a DBA was […]
PASS Elections part two
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think we need to have a “TIM” on the Board of Directors. 🙂 I have known Tim for a few years now. We have attended numerous events together over the years and contributed to a number […]