SQL Server with Mr. Denny:

SQL Server


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 6, 2010  2:00 PM

Microsoft SQL Server’s MDS has come a long way.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2008 R2

OK, now that I have your attention pretty much nothing has changed in Denali's Master Data Services.  The install procedure is a bit different now but that is about it.  To install the Denali version of MDS just run through the normal SQL Server installer.  When you get to the service list page...


December 2, 2010  2:00 PM

Will separation of data file and log file of SQL sever help if all are on the SAN? From performance perspective not management.



Posted by: Denny Cherry
EMC, IBM, SQL Server, Storage

Most likely yes, but it really depends on the storage array and the storage array configuration.  If the array is a shared everything array like an IBM XIV then their may not be any benefit to breaking everything onto separate disks as each LUN is spread over every spindle in the device.  However...


November 29, 2010  11:00 AM

I’ll be presenting a pre-con at #sqlsat62 in Tampa, FL.



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

If you wanted to go to my pre-con at the SQL PASS Summit, but you couldn't make it, or you couldn't get the boss to approve the $400 price tag that PASS was charging do I have a deal for you.  I'll be presenting the same pre-con (hopefully better after integrating feedback from the PASS summit) as...


November 25, 2010  11:00 AM

What are the best counters or KPIs to identify what dirves woudl benefit from EFD’s and can be used to reflect before and after performance metrics?



Posted by: Denny Cherry
SQL Server, Storage

EFDs (Enterprise Flash Disks) or SSDs (Solid State Disks) are all the rage today for systems which have very high IO load requirements.  But knowing if your disks would benefit from this technology can be a bit of a problem if you don't know where to look.  After all these disks are not...


November 22, 2010  11:00 AM

What should be done for a Transaction log drive (array) to make sure the log records are ON the disk, even if the power fails?



Posted by: Denny Cherry
Cache, SQL Server, Storage

This is a great question that I got a while back during a web cast that I did during the 24 Hours of PASS.  Most storage arrays, at least the better quality ones, have a battery within them which will keep a portion of the array online in the event of a power outage.  While the array won't be...


November 18, 2010  11:00 AM

Given that LiveMotion, etc give you high availability in the event of a server failure, why would you put a SQL cluster on VMs?



Posted by: Denny Cherry
Hyper-V, SQL Server, Virtualization, VMware

This question comes up every once and a while when designing a virtualization solution for someone.  When building a virtualization solution (either Hyper-V or VMware) you get some great free HA solutions included when you build a cluster so why would you want to go through the pain of creating a...


November 15, 2010  11:00 AM

A service restart is a service restart



Posted by: Denny Cherry
SQL Server

Every once and a while I run across someone who thinks that the way to correctly restart the SQL Server service is to use the SQL Server Configuration Manager.  That's just not the case.  You can restart the services from SSMS (if your account has rights), or from the service applet in...


November 13, 2010  10:47 PM

SQL PASS Summit 2010 In Review



Posted by: Denny Cherry
In Person Events, PASS, SQL PASS, SQL PASS 2010

This week was the 2010 SQL PASS summit in Seattle.  I would have to say that this was the best PASS summit that I have attended (this was my fourth).  There were more exhibitors that ever before, there were more attendees than we've had in a very long time, and I think that lots more people had a...


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: