SQL Server with Mr. Denny:

ITKE grandparent


February 2, 2010  11:00 AM

Taking backups is good, but testing them is better.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Restore Database, Testing

I bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was.  But if I asked you when the last time your database was restored successfully would you know?

January 21, 2010  11:00 AM

SQL PASS Session Stats



Posted by: Denny Cherry
Evals, In Person Events, PASS

So I got my session stats from my SQL PASS presentation a little while back, but I've been so busy I haven't been able to put up a post about them. My Session was DBA-421 Storage for the DBA. I had a great response rate on the evals with 66 evals turned in (there were about 100-120 people in the...


January 18, 2010  11:00 AM

How I design a database



Posted by: Denny Cherry
Database Design

Last week Buck Woody asked how we all design our databases, so here's my answers to his questions and a little about my process. I'll get to #1 in a...


January 15, 2010  2:03 AM

Today’s plagiarism incident…



Posted by: Denny Cherry
Allen Kinsel, Brent Ozar, DCMA, Paul Randal, Plagiarism, SearchSQLServer.com, SQLServerPedia.com, Todd McDermid, Twitter

If you are on Twitter and you follow some of the more popular people on twitter (BrentO, PaulRandal, SQLInsaneo, myself, etc)...


January 14, 2010  11:00 AM

My professional goals for 2010



Posted by: Denny Cherry
Certifications, Connections, EMC World, Professional Development

It being the new year (ok, so I'm a couple of weeks late) it is time to come up with my professional goals for the new year. Continued »


January 11, 2010  11:00 AM

Making sense of Parallel Data Warehouse for SQL Server 2008 R2



Posted by: Denny Cherry
Article, SearchSQLServer.com, SQL Server 2008 R2

I've got a new article up on SearchSQLServer.com where I talk a bit about the new Parallel Data Warehouse edition of SQL Server 2008 R2. Denny


January 7, 2010  11:00 AM

Not everything needs a public IP address.



Posted by: Denny Cherry
SecurityFightClub, Storage

For those of you in bigger shops you can probably ignore this.  If you work in a smaller shop where everything in the datacenter has a public IP, this post is for you.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 4, 2010  11:00 AM

When setting up a new Windows Cluster test failover before releasing to production



Posted by: Denny Cherry
Clustering, Microsoft Cluster Service

When you build a new Microsoft Cluster Server cluster always be sure to fail over all the drives between all the nodes before installing SQL Server on it and deploying the cluster to production.  The first time that you fail over a cluster from one node to another the disks can take a very long...


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance



Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...


December 17, 2009  11:00 AM

CXPacket isn’t the cause, it is a symptom



Posted by: Denny Cherry
SQL

All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t.


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: