-
PASS 2014 Nomination Committee
I’m officially on the slate and running for the PASS 2014 Nomination Committee! Why should you vote for Ryan? I love the PASS SQL Community and everything it embodies. … Continue Reading
-
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature. If you are unfamiliar with the… Continue Reading
-
Central Management Server White Paper
Below is a link to a white paper I wrote on Central Management Server. This white paper is an excellent guide for those who have never used it… Continue Reading
-
Policy Based Management White Paper
Below is a link to a white paper I wrote on Policy Based Management. It serves as a guide to not only explain the technology but also walk… Continue Reading
-
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise. So although this is no longer new information,… Continue Reading
-
SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a quick review of ports in SQL Server. A… Continue Reading
-
Reinstall SQL Server Performance Counters
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It sounds odd to have them magically disappear, but… Continue Reading
-
SSPI Handshake Failed
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error he was receiving: SSPI handshake failed with error… Continue Reading
-
Configure Kerberos for SQL with Virtual Accounts
At a conference recently I had someone ask how they would configure Kerberos for accounts that look like “NT Service\MSSQLServer” or “NT Service\MSSQL$MyInstance”. Please note that these are… Continue Reading
-
Error Authenticating Proxy | SQL and UPNs
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let me qualify that a little. It wasn’t misleading… Continue Reading
-
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy? The answer to this question requires that we step… Continue Reading
-
Active Directory and SQL Server Questions Answered
I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can affect your SQL Server. We only had an… Continue Reading
