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 […]
Category: Tibits
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 […]
PASS Elections
I as well as many others have a decision to make on who I am voting for the PASS Board of Directors. I haven’t made my mind up completely for all the votes I get to cast but one vote for sure is for Allen Kinsel. Why is my mind made up for Allen you […]
Professional Etiquette When Sending Mass Email – Use BCC:
<begin soap box rant> Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email. The main rule of thumb I tell the senders is that if dialog is not needed between everyone on the […]
Cannot create Cluster – the computer X is joined to a cluster
Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”. My first thought then was to […]