SQL Server with Mr. Denny:

SQL Server


January 4, 2011  2:00 PM

Ever have this conversation?



Posted by: Denny Cherry
In Person Events, SQL Saturday, SQL Saturday 62, SQL Server, Storage, Virtualization

Have you ever had this conversation with your storage admin? [kml_flashembed movie="http://www.youtube.com/v/yZlbLkD46Kc" width="425" height="350" wmode="transparent" /] If you have, then do I have a session for you to attend.  On January 14, 2011 in Tampa, FL I'll be presenting...

January 2, 2011  2:00 PM

Cloud and the law



Posted by: Denny Cherry
Abandoned Property, Distaster Recovery, International Law, Laws, Lawyers, Patriot Act, SQL Server

Moving data into the cloud is a huge thing with Microsoft and Amazon (among others).  However for those in countries that aren't the US there are some major road blocks to putting your data into the cloud. The first issue is that when the cloud provider is a US company (which most of them are...


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


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: