SQL Server with Mr. Denny:

ITKE grandparent


March 21, 2009  11:26 PM

What does the community want to see at PASS?



Posted by: Denny Cherry
In Person Events, PASS

So, as you may have heard the SQL PASS 2009 Call for Speakers has gone out.  I've submitted a couple of sessions already, but I was hoping to get some feedback from the community at large about what you think I should submit topics on. I've submitted a couple of SQL Service Broker sessions, as...

March 17, 2009  10:50 PM

Slide Decks and Sample code from Quest Day with the Experts



Posted by: Denny Cherry
Brent Ozar, In Person Events, Quest Software, Service Broker, SQLServerPedia.com

The slide decks and sample code that Brent and I presented with have been uploaded.  The recordings have to be...


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


February 28, 2009  12:21 AM

WebEx and Windows 7



Posted by: Denny Cherry
WebEx, Windows 7

Apparently WebEx and Windows 7 doesn't play nice very well. I have been working from home recently and normally I just RDP into my workstation at the office.  Today I was working with Quest Tech Support and they setup a WebEx session for me.  When I fired it up on my workstation (like I've...


February 23, 2009  11:00 AM

What exactly is a NULL?



Posted by: Denny Cherry
NULL

NULL values are something that a lot of people just don't understand the use off. Continued »


February 16, 2009  9:53 PM

Processing XML files with SQL Server functions



Posted by: Denny Cherry
OPENXML, SearchSQLServer.com, XML

I just published a new article on SearchSQLServer.com called Processing XML files with SQL Server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: