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.

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, 402 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, 362 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, 338 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, 325 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, 5,496 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, 361 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, 489 reads

Posted in Ryan Adams on 15 May 2012

SQLRally Can’t Miss Events

Things have been quiet around here lately and I have a one word explanation….SQLRally.  There’s work and family and several other community commitments, but mostly SQLRally.  The good news is that the time has come and I couldn’t be more excited.  I haven’t been to a SQLSaturday or community event… Read more

10 comments, 301 reads

Posted in Ryan Adams on 5 May 2012

Configure Anti-Virus on your SQL Server

This week I had an application team report the error “SQL Connection Lost”.  Fortunately they also reported the exact times of occurrence, which made it much easier to hunt down.  I did some digging through the SQL logs and DMVs, but did not find anything that indicated SQL was dropping… Read more

10 comments, 1,260 reads

Posted in Ryan Adams on 6 March 2012

Learn Mirroring with me at SQLRally

I just found out that I will be speaking at SQLRally Dallas in May.  I submitted 3 sessions.  As an event organizer, all 3 automatically went to community vote.  I am very excited that my Mirroring session was voted in.  Thank you to everyone who voted for me!

Mirroring Start…

Read more

10 comments, 309 reads

Posted in Ryan Adams on 27 February 2012

Speaking at PASS DBA Virtual Chapter

I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012.  I will be delivering my presentation on Mirroring.

If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out.  These chapters are designed to fill the… Read more

10 comments, 310 reads

Posted in Ryan Adams on 20 February 2012

Performance VC Feb Meeting

Jes Borland will be speaking for the Performance Virtual Chapter this month.  Don’t miss out on this free training.  Here are the details and click the link to visit the chapter website for the LiveMeeting link and to add to your calendar:

Read more

10 comments, 350 reads

Posted in Ryan Adams on 17 February 2012

SQLCruise: The Trident

Move over Poseidon.  I’m hitting the sea with my own trident (assuming I can get it through the TSA).  My trident is made from the culmination of my favorite three things.  My wife, SQL Server, and cruising.  Let me explain.

Back in October of last year, Idera ran a contest… Read more

10 comments, 387 reads

Posted in Ryan Adams on 26 January 2012

PASS Performance VC Reboot

The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant this chapter needed some additional hands on deck. Erin Stellato (Blog|Twitter) valiantly volunteered to take the helm and she put out an SOS for volunteers.  The… Read more

10 comments, 285 reads

Posted in Ryan Adams on 24 January 2012

Setup Alerts for PBM

PBM raises errors for policy violations.  We can create alerts on those errors to be notified of policy violations.  In order to setup alerts on these errors there are three prerequisites.  Note that violations for the “On Demand” evaluation mode do not raise errors.  A policy must be set to… Read more

10 comments, 921 reads

Posted in Ryan Adams on 7 December 2011

SQLRally 2012 Registration Open

The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community.  We are excited to announce that event registration opens November 30, 2011.

Make sure to get registered soon… Read more

0 comments, 594 reads

Posted in Ryan Adams on 30 November 2011

See if Auto Create Statistics is enabled using PBM

We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”.  First we need to open SQL Server Management Studio and connect to our server.  Then we need to enable Policy Management by expanding the Management node, right clicking on Policy… Read more

0 comments, 769 reads

Posted in Ryan Adams on 21 November 2011

Import MS Best Practice Policies

Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server.  You can also import policies that you have exported from other servers.  The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by… Read more

0 comments, 517 reads

Posted in Ryan Adams on 25 October 2011

How to setup CMS

If you need to setup a Central Management Server or just want to check it out, then here is how to do it.

Open SQL Server Management Studio and connect to the SQL instance you want to host your CMS.  By default SSMS does not show you the Registered Servers… Read more

0 comments, 450 reads

Posted in Ryan Adams on 9 August 2011

How to move Cluster MSDTC Drive

I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive.  Let’s just walk through the basic steps.

The first thing you need to do is… Read more

0 comments, 1,326 reads

Posted in Ryan Adams on 28 July 2011

Newer posts

Older posts