Author: Brandon Abshire
Brandon has worked in IT for nearly 20 years, and currently serves as a SQL Server DBA for a healthcare company in California. In his spare time, he runs for miles and helps maintain Brandon is a certified SQL Server administrator.

SQL Server / Windows OS losing connection to Domain Controllers

SSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. No authority could be contacted for authentication.

Posted in Active Directory, Security, SQL Server, Windows

Sudden High CPU Utilization and Query Performance Decrease | When Query Plans Go Bad

Each morning when I get into the office, I check performance graphs in SolarWinds Database Performance Analyzer (DPA – formerly Confio Ignite).  Monday mornings are usually the most important, because I run full system maintenance on a specific monitored database

Posted in SQL Server

[SOLVED] Degraded Performance on HP DL580 G7 on BIOS v. 7/01/2013

After a December 2013 patching downtime, I noticed an abrupt decrease of almost 50% in the performance of 2 SQL Servers.  Both servers were running on HP DL580 G7s.  After many hours of testing and data collection, we finally updated

Posted in SQL Server, Windows

SQL Troubleshooting: Searching the Plan Cache for Missing Indexes and Execution Statistics

I’ve always found basic administration of SQL Server to be fairly straight-forward, but for a long while, I felt very uneasy about troubleshooting SQL Server performance issues.  Any DBA knows that the most productive periods of learning arise when there

Posted in SQL Server

SQL Server System Processes Blocking User Processes when Auto Update Stats Async is Enabled.

Recently, we decided to buy a few licenses of Confio Ignite (Now SolarWinds Database Performance Monitor) to monitor some of our high-profile SQL Servers.  I’m definitely not posting a sales pitch, but for me, it’s provided insight into SQL Server

Posted in SQL Server

SQL Server: Cannot Generate SSPI Context and KRB_AP_ERR_MODIFIED Errors

As DBAs, one of the most  common tasks performed is the installation of new SQL Servers.  While I’ve installed hundreds of SQL Server instances over the years, I only recently come across the error described below.  In the past, I’ve seen

Posted in Active Directory, SQL Server

Mounting NAS Volumes in Mac OS X the Right Way

I’ve been using Mac OS X for a while now, but upgraded to a 13-inch Macbook Pro Retina about a year ago.  I love having access to the command line and I just RDP when I need to do anything

Posted in OS X & iPhone

Running Lync 2010 with a SQL Server 2012 Backend

Recently I was tasked with migrating all SQL 2008 R1 and prior databases to SQL 2008 R2 and SQL 2012.  One of my qualifying applications was Lync 2010.  We were under the impression that SQL 2012 would be fine for

Posted in Lync, SQL Server