SQL Server with Mr. Denny:

November, 2010


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  11:11 PM

I’ve started my new job



Posted by: Denny Cherry

I am happy to report that on Monday I'll be starting my new job with Phreesia who are based in New York, NY. I'll be working from home pretty much full time with occasional trips to the office. When I get a chance I'll post more info about my new job and company. Denny


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


November 11, 2010  6:01 PM

SQL PASS 2010 Day 3 Keynote



Posted by: Denny Cherry
PASS, SQL Server

Today’s keynote started with Rick giving us some important news.  He first announced that the SQL Rally website has gone online for the first SQL Rally event as well as the first SQL Rally pre-con speakers.  The date and location of the next SQL PASS summit has also been announced as...


November 11, 2010  4:58 PM

SQL PASS 2010 Day 2 Keynote



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

Today was the second day of the SQL PASS summit. The first item of business was to award The passion award to Wendy Pastrick (blog | twitter) . After the awesome award was given out by Bill Graziano, Bill...


November 9, 2010  5:59 PM

SQL PASS 2011 Day 1 Keynote



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

Today was the first day of the SQL PASS summit. Starting the day with the keynote where a Laptop was given away to a member of the audience by Mark Souza (Twitter) the founder of the SQL CAT team. Ted Kummert was our...


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: