SQL Server with Mr. Denny:

Storage


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

January 2, 2009  8:46 PM

Mirroring isn’t a backup solution



Posted by: Denny Cherry
Backup & recovery, Database security, JournalSpace.com, SecurityFightClub, SQL Injection

In case you live under a rock and haven't heard about Journalspace.com's little mistake, they have gone out of business due to a database problem.  Here's a


December 29, 2008  11:00 AM

Order To Restore Database Backups In



Posted by: Denny Cherry
Backup & recovery, Restore Database, RESTORE LOG

I'm often asked (both online and offline) once you have all your database backups, in what order to they need to be restored in? I've actually asked this very question to senior level DBAs as an interview question before, and gotten some very interesting answers. When restoring your database...


December 4, 2008  7:55 AM

Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)



Posted by: Denny Cherry
Instant File Initialization, Performance Problems, Storage

SQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files). While this is great when creating your database, or extending your database files there is a cost to...


November 25, 2008  11:39 PM

How to configure storage in SQL Server DB with more writes than reads



Posted by: Denny Cherry
Storage

All to often articles and presentations about storage work under the assumption that you have a typical OLTP database with mostly reads. However there are plenty of databases out there which are mostly writes and very few reads. Setting these systems up takes a different technique for best...


October 25, 2008  11:00 AM

Slide Decks and Sample Code for SoCal Code Camp at USC



Posted by: Denny Cherry
Back To Basics, Federated Database, In Person Events, SoCal Code Camp, Storage

Here are the slide decks and sample code from my sessions at this weekends SoCal code camp.

  Bookmark and Share     4 Comments     RSS Feed     Email a friend


September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication



Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...


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


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: