SQL Server with Mr. Denny:

SQL Server 2005


September 11, 2008  11:00 AM

Service Broker may not remove messages after processing



Posted by: Denny Cherry
END CONVERSATION, Service Broker, SQL, SQL Server 2005, TempDB

I've seen an issue with Service Broker that others may be seeing.  Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue.  However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...

September 2, 2008  7:30 PM

Get SQL Server log shipping functionality without Enterprise Edition



Posted by: Denny Cherry
Article, Log Shipping, SQL Server 2000, SQL Server 2005, SQL Server 2008

A new tip of mine has just been published on SearchSQLServer.com.  This tip, "Get SQL Server log shipping functionality...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 1, 2008  11:00 AM

Getting more error data from SQL Server Replication



Posted by: Denny Cherry
distrib.exe, logread.exe, OutputVerboseLevel, Replication, replmerg.exe, snapshot.exe, SQL Server 2000, SQL Server 2005, SQL Server 2008

The error reporting in SQL Server Replication isn't all that great.  This is a well known issue that pretty much everyone knows about.  Something that I don't know if a whole lot of people know about, is that there is a way to get a lot more information from replication about what's going on, and...


August 26, 2008  7:55 PM

Don’t Consolidate Yourself Into Performance Problems – Archive



Posted by: Denny Cherry
Capacity Manager, Consolidation, David Swanson, Performance Problems, Quest Software, SoSSE, SQL Server 2005, SQL Server 2008

The webcast which I did for Quest Software called Don’t Consolidate Yourself Into Performance Problems is now available for viewing after the fact. This is the webcast which I did


August 25, 2008  11:00 AM

How to setup a server to read log files nightly.



Posted by: Denny Cherry
Backup & recovery, KILL, Log Shipping, Recovery, RESTORE LOG, SQL Server 2005, xp_delete_file, xp_dirtree

So you've been tasked with setting up a quick and dirty reporting server.  The goal is to restore the log files from the production server to the reporting server nightly.  The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine.  But...


August 21, 2008  11:00 AM

SoCal Code Camp Sessions are posted



Posted by: Denny Cherry
Back To Basics, Code Camp, In Person Events, Service Broker, SoCal Code Camp, SQL Server 2005, SQL Server 2008, Storage

I and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th...


August 14, 2008  11:00 AM

I’ll be speaking at the New Jersey SQL Server Users Group next week



Posted by: Denny Cherry
In Person Events, New Jersey SSUG, Service Broker, SQL Server 2005, SQL Server 2008

After months of waiting the time is finely here.  I'll be speaking at the   Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 13, 2008  1:05 AM

Don’t Consolidate Yourself Into Performance Problems



Posted by: Denny Cherry
Capacity Manager, Consolidation, David Swanson, Performance Problems, Quest Software, SoSSE, SQL Server 2005, SQL Server 2008

Consolidated too many databases or too many instances onto a single server?  Got users screaming for their own servers back? Join myself and David Swanson from Quest Software (and frequent poster on 

Bookmark and Share     2 Comments     RSS Feed     Email a friend


July 28, 2008  11:00 AM

You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server



Posted by: Denny Cherry
RDL, SQL Server 2005, SQL Server 2008, SSRS

SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren't compatible.  You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won't be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it...


July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command



Posted by: Denny Cherry
Back To Basics, BACKUP DATABASE, SQL, SQL Server 2000, SQL Server 2005

Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion.  This would be done by taking backups of the database.  Backups are taken by using the BACKUP DATABASE command. The...


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: