SQL Server with Mr. Denny:

August, 2008


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 20, 2008  10:58 PM

I had a great talk with the NJ SQL User Group last night



Posted by: Denny Cherry
Awareness Technologies, In Person Events, Laptop Cop, Quest Software, Service Broker

Last night was my talk with the NJ SQL User Group.  I would jut like to thank them for the invite, I had a great time coming and speaking with them.  It was a very interactive night, with a lot of questions. 

Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 19, 2008  4:52 PM

Tuning SQL Server performance via disk arrays and disk partitioning



Posted by: Denny Cherry
Article, Disk Alignment, Diskpart, Storage

I've published another tips on SearchSQLServer.com called "Tuning SQL Server performance via...

Bookmark and Share     13 Comments     RSS Feed     Email a friend


August 18, 2008  11:00 AM

Great article about how Microsoft prevents cheating on the certification exams.



Posted by: Denny Cherry
Certifications

A while back I was flipping through the Microsoft news groups and found a link to an excellent story that networkworld.com put together on how Microsoft is protecting it self from brain dump sites...


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  10:37 PM

Why Entry-Level Certs Aren’t Enough to Get You a Job



Posted by: Denny Cherry
Certifications, Ed Tittle, IT careers

Ed Tittel has written an excellent post on his blog (IT Career JumpStart) entitled

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


August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command



Posted by: Denny Cherry
Back To Basics, Restore Database, SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


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: