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.

Database Mail Breaks with TLS 1.0 Disabled

Discovery I ran across an issue where I had just configured database mail on a new server, went to send a test email, and I waited to receive it.  I waited…and waited…and waited, but still nothing.  I started to investigate and verified that database mail was indeed enabled, Service Broker… Read more

2 comments, 1,467 reads

Posted in Ryan Adams on 5 July 2016

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as I do not speak on behalf of PASS. I have been on the PASS Board of Directors for about 4 months now and we had our first in person board… Read more

0 comments, 237 reads

Posted in Ryan Adams on 18 April 2016

Query Active Directory from SQL Server

Have you ever had the need to query Active Directory right out of SQL Server using native TSQL?  There are 3 ways to accomplish this.  The first is CLR, but I won’t be covering that method.  The other two methods are OPENROWSET and OPENQUERY.  OPENROWSET requires Ad Hoc Distributed Queries… Read more

7 comments, 3,046 reads

Posted in Ryan Adams on 15 March 2016

SQL Server on Linux Authentication

Yesterday Microsoft announced that they will now support SQL Server on Linux.  They are targeting mid-2017, but you can download a preview now.  I am on a technical list where I saw someone inquire about the support for Windows authentication or if SQL authentication would be the only choice.  Those… Read more

6 comments, 1,818 reads

Posted in Ryan Adams on 11 March 2016

Fix a Network Binding Order Warning

Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance or a SQL Server Availability Group) is regarding an incorrect network binding order.  You will see this presented as a warning in… Read more

1 comments, 998 reads

Posted in Ryan Adams on 26 February 2016

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, 391 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, 961 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

5 comments, 1,223 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, 236 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, 249 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

10 comments, 226 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. Election Landing Page My Board Qualities PASS Election Questions Answered Question 1 If elected, what would prompt you to step… Read more

10 comments, 337 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

10 comments, 272 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

10 comments, 230 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

10 comments, 293 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, 808 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, 856 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, 705 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, 427 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, 540 reads

Posted in Ryan Adams on 30 July 2015

Older posts