Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ryan Adams

Ryan Adams has worked for Verizon for 15 years. His primary focus is the SQL Server Engine, high availability, and disaster recovery. Previously he was a Senior Active Directory Architect and designed the company's worldwide Active Directory infrastructure. He serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.

I’m a SQL Server MVP!

I was just awarded as a Microsoft SQL Server MVP!

I can’t believe Microsoft has chosen me for this award and to be included in such a prestigious program.  There are only a little over 70 SQL Server MVPs in the United States and a little over 350 world wide. Read more

7 comments, 131 reads

Posted in Ryan Adams on 1 October 2014

PASS 24HOP AlwaysOn Questions Answered

I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event.  You can view the session recording HERE if you missed it.  The session was a preview of the full session I will be presenting at the PASS Summit 2014 this November.… Read more

0 comments, 104 reads

Posted in Ryan Adams on 30 September 2014

A Bad Day with Backups


I learned a hard lesson when I first started as a DBA.  Although to be honest, it’s not a lesson I should have had to learn (I’ll keep you in suspense).  I work for a large Fortune 100 company and as with many companies our size, there are many processes… Read more

3 comments, 6,194 reads

Posted in Ryan Adams on 25 September 2014

SQLSaturday Precon Cost Structure

Many of you may already know that I am a PASS regional mentor for the South Central region of the United States.  My role is to help user group leaders obtain the tools they need to have successful groups and provide an open platform to discuss challenges and successes.  One… Read more

4 comments, 93 reads

Posted in Ryan Adams on 18 August 2014

HA and DR Precon in Denver

 

I’ll be doing a precon for SQLSaturday #331 in Denver Colorado on September 19th, 2014 titled “A Day of High Availability and Disaster Recovery” .  If you can make it, I would love to have you in the class.  We are going to cover backups, windows clustering, AlwaysOn Failover… Read more

6 comments, 107 reads

Posted in Ryan Adams on 2 July 2014

HA and DR Precon in Baton Rouge

I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 2014 titled “A Day of High Availability and Disaster Recovery” .  If you can make it, I would love to have you in the class.  We are going to cover backups, windows clustering, AlwaysOn Failover… Read more

0 comments, 120 reads

Posted in Ryan Adams on 30 June 2014

Speaking at PASS Summit 2014

I am excited and humbled to be speaking at the PASS Summit for my second year in a row! There were 943 submissions and only 144 spots, so I am really excited and honored to be a part of the largest and most amazing SQL Server conference in the world.… Read more

0 comments, 140 reads

Posted in Ryan Adams on 27 June 2014

Kerberos Configuration Manager’s Nasty Bug

The Kerberos Configuration Manager is a really handy tool that can make configuring Kerberos a much easier task, but it’s got a nasty little bug.  Configuring Kerberos can be tricky.  In what way you ask?  Here is a short list of just some of the things you have to consider. Read more

2 comments, 219 reads

Posted in Ryan Adams on 17 June 2014

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.  I am very involved at the local and regional level.  I know all of the current board members and most of… Read more

0 comments, 128 reads

Posted in Ryan Adams on 2 June 2014

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 new feature in SQL 2012 that allows you store TempDB on a local drive in a failover cluster you can read more… Read more

0 comments, 193 reads

Posted in Ryan Adams on 8 May 2014

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, it has not been talked about all that much.  I’m talking about the new feature in SQL Server 2012 that allows you… Read more

10 comments, 582 reads

Posted in Ryan Adams on 11 March 2014

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 default instance of SQL Server uses port 1433.  That’s just the default and you can change it to whatever you want.  Bear… Read more

10 comments, 320 reads

Posted in Ryan Adams on 3 March 2014

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 I’ve found a 3rd party monitoring product to be the culprit.

First we need to unload the counters just to make sure… Read more

10 comments, 1,520 reads

Posted in Ryan Adams on 25 February 2014

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 code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error… Read more

10 comments, 1,430 reads

Posted in Ryan Adams on 18 February 2014

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 NOT the built-in system accounts, even though they look similar.  The system accounts are “Local System”, “Local Service”, and “Network Service”.  The… Read more

10 comments, 1,269 reads

Posted in Ryan Adams on 10 February 2014

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 in the sense of it saying one thing and meaning another.  It was misleading because it’s one of those errors you see… Read more

10 comments, 673 reads

Posted in Ryan Adams on 4 February 2014

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 outside the DBA comfort zone since it requires the use of Active Directory and Group Policy Objects.  There are many different ways… Read more

10 comments, 468 reads

Posted in Ryan Adams on 20 December 2013

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 hour so I had to scale the content back and because of that I had a ton of questions.  I answered what… Read more

10 comments, 1,851 reads

Posted in Ryan Adams on 18 December 2013

SQL Service Account Recursive Group Membership

It was recently brought to my attention that a post with the script I talk about below could not be found on my blog.  Either I thought I blogged about it and never did or it got lost when I had to change hosting providers late last year.  My apologies… Read more

10 comments, 175 reads

Posted in Ryan Adams on 18 November 2013

Where I’ll Be

Things have been too quiet here on the blog, but there’s a reason (a few actually).  This year has been nuts for me, but it’s all good stuff!  We just moved, and moving a family is not fun.  It was a long process from selling the old house to searching… Read more

10 comments, 255 reads

Posted in Ryan Adams on 1 August 2013

Older posts