Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts published by Ryan Adams

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 SQL Server”. I have been [...]

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 are dependent on the facets [...]

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 the error while creating a [...]

In early February I received an email from LinkedIn that I have one of the top 1% most viewed profiles for 2012.  That’s really cool and I had no idea!  In fact, I couldn’t remember the last time I had updated it.  This prompted a serious, “Dude you better get out there and do some [...]

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 2 years (I just started a [...]

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 community evangelist, and better IT [...]

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 Ted Kummert who will talking [...]

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 strong feelings about two of the candidates and [...]

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 be done.  The first thing I [...]

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 board members and those relationships have [...]