Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in SQLServerCentral Syndication

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 it will no longer be […]

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 did you assign the endpoint […]

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 Name (SPN) [ MSSQLSvc/Node1.stars.com:1433 ] […]

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 I just added some comments […]

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 backups, windows clustering, AlwaysOn Failover Cluster Instances, […]

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 I know there are some […]

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. Election Landing Page My Board Qualities PASS Election Questions Answered Question 1 If elected, what would prompt you to step down before the end of […]

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.  I also want our members to […]

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 in 2013 and we knew changes […]

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.   Election Landing Page This Post PASS Election Questions Answered […]