Twice in the last two weeks I’ve been pulled into a “the server is pegged at 100% CPU and we don’t know why” fire drill, and twice the fix turned out to be a single hint on one line of code.
Windows logins to a SQL Server AG started throwing “Cannot generate SSPI context” — but only sometimes, and only for some people. We solve it.
Service account management is one of the quietest ways a SQL Server estate goes wrong. Passwords get set once during
If you’ve encountered a situation where none of your SQL Server Always On Availability Group (AG) replicas become PRIMARY after a cluster failure — you’re not alone. We recently had a customer with this exact scenario (AG won’t become primary after force quorum), and it is both uncommon and difficult to troubleshoot so I thought it would be worth posting about.
Our Health Check is a great starting point with our clients. It tells us a lot about their instances, such
One of the things we see as consultants are consistent patterns of behavior by T-SQL developers that cause big performance
One of the things I have found over the years is that it is easy to get into a rut
I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks
I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014
