SQL Server with Mr. Denny:

December, 2010


December 30, 2010  2:00 PM

We are currently running on an EMC SAN. Did I hear you correctly, we should have databases, backups, temp, and logs on the same LUN? Thanks.



Posted by: Denny Cherry
EMC, SQL Server, Storage

No, you want to put them on different LUNs.  IBM is currently recommending that on the XIV array that everything can be put on a single LUN as the LUN is spread over all the disks in the array.  For an EMC array you’ll want to have separate LUNs for each. Denny

December 28, 2010  11:33 PM

Some people really just don’t understand how the technology that runs their lives functions.



Posted by: Denny Cherry
New York Times, Social Commentary, SQL Server, Technology, Tom Groenfeldt

So I'm sitting at home reading an article on the NY Times website about the current travel mess in New England, and a statement within the article really scared me (about 2/3s of the way down).

"He wonders why during...


December 27, 2010  2:00 PM

My book “Securing SQL Server” is coming.



Posted by: Denny Cherry
Book, Security, SQL Server

I'm happy to say that I officially can't make a single change to my book "Securing SQL Server". The publisher made the last little changes and sent it to the...


December 23, 2010  5:14 PM

What should Developers know about SQL Server?



Posted by: Denny Cherry
Deep Fried Bytes, Pod Cast, Robert Cain, SQL Server, Tech Ed

Back at Tech Ed 2010 a good friend Robert Cain (blog | twitter) and I were wondering the exhibit hall floor and we got stopped by the guys from the Deep Fried Bytes pod cast and they asked us if we'd be willing to sit...


December 23, 2010  2:00 PM

Do you have any affordable recommendations (mid-size company) for DR to a secondary site, about 11 TB of storage?



Posted by: Denny Cherry
DR, EMC, Storage

It depends on how you are going to handle your data replication.  If you are going to use native array based replication then you’ll need to either use array’s data replication options or look at EMC’s recover point. If however you are going to handle the replication outside of the...


December 20, 2010  2:00 PM

Database Restores and Torn Pages



Posted by: Denny Cherry
Log Shipping, SQL Server, Storage

This weekend I was migrating some databases from one server to another.  As these were rather large databases (about 2 TB in size) and I didn't have the clusters setup on a SAN (using DAS instead) I needed to setup log shipping from one cluster to another so that the downtime when moving was kept...


December 17, 2010  7:27 PM

MCM exam passed, time to prep for the lab.



Posted by: Denny Cherry
Certifications, MCM, SQL Server

I just received notice today that I received a passing score on the first of the MCM exams.  I must say, that the few weeks have been extremely nerve racking waiting for the results.  I took the exam the day before Thanksgiving (which was awesome since the testing center is an hour away normally)...


December 16, 2010  2:00 PM

Moving SQL database files using T/SQL only.



Posted by: Denny Cherry
SQL Server

So last week I needed to rename some physical database files so that I didn't have any naming conflicts when I restored some other databases.  I had about 10 databases that I needed to rename both the physical database files as well as the databases, and I really didn't want to detach each...


December 13, 2010  2:00 PM

SQL Saturday #62 looks like it is going to be a great event



Posted by: Denny Cherry
SQL Saturday, SQL Server

The first SQL Saturday of 2011 is looking like it is going to be an awesome event.  One reason that I can say that a month ahead of time is that for the first time (as far as I know) speakers have to be turned away because there have just been so many speakers submitting sessions.  I count 94...


December 9, 2010  2:00 PM

Do we have to worry about disk alignment if we have an EMC san?



Posted by: Denny Cherry
EMC, Storage

Yes.  Every storage platform no matter what vendor makes it needs to be correctly aligned.  If the disks aren’t correctly aligned then you are doing twice as much work for every read and write operation than you need to be doing. Fortunately new volumes created on a Windows 2008 or higher...


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: