Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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.

Change Availability Group Endpoint Port

Let’s say you have a port conflict and need to change the port on your Availability Group endpoint.  How can we accomplish this?

The first step is to change the port on the endpoint itself.  Note that as soon as you do this the replica on which you are running… Read more

0 comments, 172 reads

Posted in Ryan Adams on 19 January 2016

Change Availability Group Endpoint IP

I had someone email me and ask how they could change the IP address on their Availability Group Endpoint.  It’s no surprise that IPs need to be changed from time to time due to certain circumstances, but what you might be wondering is where during the creation of your AG… Read more

0 comments, 701 reads

Posted in Ryan Adams on 14 January 2016

Could not Register Service Principal Name

Have you ever seen the error below in your SQL Server log shortly after startup?  You’ll actually see two of them and you can see the difference between them in the screen shot, but here is the text.

The SQL Server Network Interface library could not register the Service Principal… Read more

1 comments, 1,038 reads

Posted in Ryan Adams on 17 December 2015

Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3

I ran across a bug in SSMS 2016 CTP 2 back in August.  If you try to right click and look at the properties of a 2014 availability group using the SSMS 2016 CTP you’ll get an error.  The bug had already been submitted by my friend Trayce Jordan, so… Read more

0 comments, 143 reads

Posted in Ryan Adams on 16 December 2015

High Availability and Disaster Recovery Training in Austin

I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to cover… Read more

0 comments, 128 reads

Posted in Ryan Adams on 1 December 2015

Thank You Community

All I can say is, “Wow…Thank you!”.  I won a seat on the PASS Board of Directors and it’s very surreal.  I am beyond excited, but not for what happened.  I’m excited and energized for what is to come.  PASS is young and our industry is in constant flux so… Read more

0 comments, 138 reads

Posted in Ryan Adams on 9 October 2015

PASS Election Questions Answered 2

Today I am going to continue with my PASS Election Questions and Answers series.  Here is where you can find the rest of the series and my campaign landing page.

Question 1

If elected, what would prompt you to step… Read more

0 comments, 221 reads

Posted in Ryan Adams on 17 September 2015

PASS Election Questions Answered

As we continue through the campaign period for this year’s PASS Board of Directors Election (Voting opens tomorrow morning), I want to continue to show our community members the type of board member I would be by asking myself some questions.  You can find my first questions post here.… Read more

0 comments, 166 reads

Posted in Ryan Adams on 16 September 2015

PASS Election Changes

The 2014 NomCom made some changes to how the election process works and it’s something you need to pay attention to.  It was posted on the PASS blog, but not really advertised that much so I want to highlight those changes and their importance.  I served on the NomCom… Read more

0 comments, 141 reads

Posted in Ryan Adams on 15 September 2015

My Board Qualities

I’m going to hopefully show examples of some qualities I have that will benefit me if chosen as a board member.  I’m going to do that by pretending you folks asked me some questions.  Here we go!

Here are the other posts in the series.

 

Read more

2 comments, 148 reads

Posted in Ryan Adams on 14 September 2015

High Availability and Disaster Recovery Training in Dallas

I’ll be doing a precon for SQLSaturday #447 in my home town of Dallas on October 2nd, 2015 titled “Creating a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We… Read more

10 comments, 667 reads

Posted in Ryan Adams on 8 September 2015

SSMS 2016 CTP 2.2 Setup Failure 0x81f40001

I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition).  The exact version as shown in the error is 13.0.0407.1 but in SSMS it returns 13.0.407.1.  As some of you may know, one of the new things in SQL 2016… Read more

10 comments, 460 reads

Posted in Ryan Adams on 13 August 2015

Architecture VC AlwaysOn Questions Answered

On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups.  Obviously we focused on the technology from an architectural standpoint.  We discussed a lot of things that come into play when designing an AlwaysOn infrastructure whether it be FCIs… Read more

10 comments, 452 reads

Posted in Ryan Adams on 5 August 2015

SQL in the City Seattle 2015

Redgate will be hosting another SQL in the City event on the Monday right before the PASS Summit 2015.  This is a free all day event that you can take advantage of by coming into town a little early.  The event will feature some of the best speakers and SQL… Read more

10 comments, 289 reads

Posted in Ryan Adams on 4 August 2015

SQLSaturday Dallas Precons Community Choice

The North Texas SQL Server User Group Board of Directors has decided to do something a little bit different for selecting Precons for our next SQLSaturday.  The SQLSaturday event will be held on October 3rd with the precons on October 2nd.  We have decided that since it is the community… Read more

10 comments, 273 reads

Posted in Ryan Adams on 30 July 2015

SQL HA and DR Training in Oklahoma City

I’ll be doing a precon for SQLSaturday #422 in Oklahoma City on August 28th, 2015 titled “Creating a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to… Read more

10 comments, 275 reads

Posted in Ryan Adams on 15 July 2015

8 Hours of Free Performance Training

How could you possibly argue with getting 8 straight hours of SQL Server Performance training for FREE?

You can’t!  Go check out the annual Performance Palooza hosted by the Performance Virtual Chapter on July 23rd, 2015.  This is a virtual online event open to the public and it’s absolutely free.… Read more

10 comments, 3,187 reads

Posted in Ryan Adams on 14 July 2015

Precon in Columbus OH

I’ll be doing a precon for SQLSaturday #421 in Columbus Ohio on July 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to… Read more

10 comments, 182 reads

Posted in Ryan Adams on 23 June 2015

Planning a High Availability and Disaster Recovery Plan in Puerto Rico

I’ll be doing a precon for SQLSaturday #373 in Puerto Rico on May 8th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to… Read more

10 comments, 279 reads

Posted in Ryan Adams on 14 April 2015

Planning a High Availability and Disaster Recovery Plan in Madison, WI

I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to… Read more

10 comments, 641 reads

Posted in Ryan Adams on 19 March 2015

Older posts