SQL Clone
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.

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

10 comments, 274 reads

Posted in Ryan Adams on 19 June 2018

How to Upgrade an AG Cluster to Windows 2016

Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016.  The best part is it’s not an OS upgrade, but a rebuild.  The magic is that you can join a Windows 2016 server to a Windows 2012 R2 cluster.  You can upgrade… Read more

0 comments, 53 reads

Posted in Ryan Adams on 9 November 2017

Sync SQL Logins and Jobs

In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video.  If you are using Availability Groups or Mirroring you know you need to sync SQL logins and jobs among replicas.  What are your options to sync SQL… Read more

0 comments, 562 reads

Posted in Ryan Adams on 8 June 2017

Implementing Buffer Pool Extension

Buffer Pool Extension was released in SQL 2014 so it’s not new.  It is also not advertised very much, but that’s not for lack of usefulness.  RAM is far faster than SSD and certainly arm based disks, but most databases are too big to cache into RAM.  BPE allows us… Read more

0 comments, 1,282 reads

Posted in Ryan Adams on 18 May 2017

Query Store Questions From The Field

I have had several Query Store questions come in from customers lately.  Some of the questions stemmed from things read on the internet so this video is aimed at both answering the questions and debunking some false information you might find out there.  We want concrete answers to the following… Read more

0 comments, 299 reads

Posted in Ryan Adams on 16 May 2017

Trace Flag 1117 Growth and Contention

In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in TempDB consistent.  You’ll see how growth occurs if the files are disproportionate and also the effect it has on TempDB contention with SQL Server special… Read more

0 comments, 1,181 reads

Posted in Ryan Adams on 5 May 2017

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,748 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, 408 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

9 comments, 3,545 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, 2,207 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

10 comments, 1,485 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, 874 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, 1,261 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

10 comments, 1,458 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, 376 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, 401 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, 355 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, 537 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, 441 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, 437 reads

Posted in Ryan Adams on 15 September 2015

Older posts