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.

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

1 comments, 410 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

4 comments, 141 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

5 comments, 1,143 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

0 comments, 894 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

2 comments, 976 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

0 comments, 484 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

0 comments, 250 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

0 comments, 1,632 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

0 comments, 107 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

1 comments, 170 reads

Posted in Ryan Adams on 1 August 2013

Holy Schnikes I’m Speaking at PASS Summit 2013

I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013 in Charlotte, NC.  This will be my first time to speak at this event and I can’t wait!  The session I will be presenting is titled “How Active Directory Affects… Read more

10 comments, 173 reads

Posted in Ryan Adams on 22 May 2013

Policy Based Management On Change: Prevent not available

Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information.  Today I want to talk about the “On Change: Prevent” mode and why you don’t always see it as an option.

The options you see available… Read more

10 comments, 401 reads

Posted in Ryan Adams on 26 March 2013

Renaming Server with SQL

I recently had to rename my laptop on which I have two SQL server instances.  I have a default instance and a named instance.  I actually have had the laptop renamed for awhile without any issues, but it’s not production and I don’t use it every day.  I first encountered… Read more

10 comments, 533 reads

Posted in Ryan Adams on 14 March 2013

User Group Marketing

I blogged about this back in September of 2010, but technology changes so it’s time to revisit this again.  Now I’m not anything even close to a marketing expert, but I’ve been the Director of Logistics and Communications for the North Texas SQL Server User Group for the past… Read more

10 comments, 338 reads

Posted in Ryan Adams on 11 March 2013

Summit 2012 Keynote Day2

This post is a live blog of the PASS Summit 2012 keynote from day 2 on 11/8/2012.  This post is intended to be a live note taking.

Douglas McDowell opens day 2 by giving an overview of the health of the PASS organization.  This year PASS has added an additional… Read more

10 comments, 326 reads

Posted in Ryan Adams on 8 November 2012

Summit 2012 Keynote Day1

This post is a live recap of the keynote at the PASS Summit 2012 conference.

Bill Graziano opens Summit 2012 with 3894 attendees.
Bill recognizes local and virtual chapter leaders as well as SQLSaturday event organizers.
The PASS BA conference is announced to be in Chicago in April.

Bill introduces… Read more

10 comments, 299 reads

Posted in Ryan Adams on 7 November 2012

My PASS Board Vote

I’m not a politically minded person and this is not the type of post I would normally write.  However, I’m deeply involved with the PASS organization (read chronic volunteer) and I have a vested interest in it’s success.  The reason I decided to write this is because I have very… Read more

10 comments, 276 reads

Posted in Ryan Adams on 9 October 2012

The report execution has expired or cannot be found. [rsExecutionNotFound]

I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:

The report execution has expired or cannot be found. [rsExecutionNotFound]

This report contains a very large dataset, so my first inclination was that there was some query tuning and indexing review that needed to… Read more

10 comments, 4,772 reads

Posted in Ryan Adams on 27 June 2012

PASS 2012 NomCom

I’m officially on the slate and running for the PASS 2012 Nomination Committee!

I love the SQL Community and everything it embodies.  I am very involved at the local and regional level and gained a unique view into PASS working on SQLRally.  I know most of the current and past… Read more

10 comments, 306 reads

Posted in Ryan Adams on 13 June 2012

SQLRally Dallas Slides

I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week.  As a core organizer of the event, this really made it a special week to present twice and see it all come together.  My first session was a community choice… Read more

10 comments, 422 reads

Posted in Ryan Adams on 15 May 2012

Older posts