SQL Server with Mr. Denny:

March, 2009


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...

March 11, 2009  9:05 PM

What the hell is wrong with people?



Posted by: Denny Cherry
Drunk in Public, MVP Summit, Social Commentary

I ran across the post A Culture of (Potential) Assholes: Sexual Harassment in IT on twitter today, and all I could think was "What the hell is wrong with people?" Before I go on, I'd like to go...


March 9, 2009  11:00 AM

Handy script for use when looking at blocking



Posted by: Denny Cherry
ASPState, Blocking, sys.dm_exec_sql_text, sys.sysprocesses

A while back I was looking at a clients database and we were looking at why the ASPState database was having blocking issues.  So I through this script together to show not only the blocked processes, but also the blocking processes, but also include the name of the stored procedure as well as the...


March 8, 2009  2:20 AM

Developing a SQL Server Database Backup Plan



Posted by: Denny Cherry
Article, Backup & recovery

Last week I published a new article on Enterprise IT Planet called "Developing a SQL Server Database Backup Plan" in which I go...


March 7, 2009  6:20 AM

SoCal Coffee and Code was a success



Posted by: Denny Cherry
Coffee And Code

I would have to say that the first SoCal Coffee and Code was a hit.  Only a few people came, but I wasn't sure if any were going to show, so fora  first event I'd say that a few is a success.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 5, 2009  11:00 AM

Coffee And Code in Irvine Tomorrow



Posted by: Denny Cherry
Coffee And Code, In Person Events

Don't forget tomorrow (Friday the 6th) is our first Coffee and Code in the SoCal area (at least the first that I know of). We’ll be at the Starbucks at the Tustin Market place (2959 El Camino Real


March 5, 2009  10:59 AM

Steps to Troubleshoot Connections to your SQL Server



Posted by: Denny Cherry
Connection Issues, Forums, Tech support

People ask all the time why they can't connect to their SQL Server. Here are some thoubleshooting steps that they should take in order to find out what the problem is. Please keep in mind that without knowledge of your specific problem I can only point you towards the right direction.


March 3, 2009  7:02 PM

Photo’s from last night



Posted by: Denny Cherry
Andrew Karcher, MVP Summit, Photo, Pinal Dave

A couple of people have posted pictures from last night. So far I've run across which Andrew Karcher and I were both in. Thanks to Pinal Dave for posting...


March 2, 2009  2:43 PM

Standalone SQL Agent Update 3/2/2009



Posted by: Denny Cherry
SQL

I’ve been quiet about the Standalone SQL Agent for a while now.  I haven’t forgotten about the project, in fact I’ve been busily working on it in what little free time I have.  I’ve been working on phase 2 of the project which is adding in the UI to handle job management.  Needless to...


March 2, 2009  9:00 AM

FREE Seminar: Spend a Day with the Experts – Aliso Viejo, CA



Posted by: Denny Cherry
In Person Events, Quest Software, SoSSE

Quest has put together a one day free seminar at the Quest Software office on Friday March 13, 2009. Brent Ozar and myself will be presenting several presentations on SQL Server 2008. For more information and to register for the event visit