SQL Server with Mr. Denny:

SQL Server


January 26, 2011  6:57 PM

When the demo’s don’t work the men and woman are seperated from the boys and girls.



Posted by: Denny Cherry
Buck Woody, In Person Events, Jonathan Kehayias, Problems, Pual Randal, Speaking, SQL PASS, SQL PASS 2010, SQL Server, SSWUG, Wendy Pastrick

So a couple of nights ago Paul Randal (Blog | Twitter), Wendy Pastrick (Blog | Twitter), Jonathan Kehayias...

January 24, 2011  11:20 PM

OK everyone, it’s SQL Rally voting time



Posted by: Denny Cherry
AlwaysOn, SQL PASS, SQL Server, SQL Server 11, SQL Server 2012

So it is time for another vote for the second category that I have a SQL Rally session submitted for.  This time the vote is for the "Enterprise Database Administration & Deployment" track. I've got a session up titled "Using SQL...


January 24, 2011  3:00 PM

Book release must be getting close, sample pages now available on Amazon.



Posted by: Denny Cherry
Book, Security, SQL Server

So, I'm guessing that my first solo book must be getting close to shipping.  You can now flip through the first 11 pages of "Securing SQL Server" (


January 24, 2011  2:00 PM

Your job is to make the systems run at their top performance.



Posted by: Denny Cherry
Social Commentary, SQL Server, Storage

So I got an email from someone (and yes he told me that I can publish this post about it) because he was having an argument with his storage / systems team about LUN config for the SQL Servers.  He wanted smaller LUNs so that they could be more easily moved around if performance problems showed up...


January 18, 2011  2:00 PM

The SQL Rally (#sqlrally) voting as started, and I’ve got a session up for vote this week.



Posted by: Denny Cherry
Data Security, Database security, SQL PASS, SQL Server

The SQL PASS organization has taken a different approach to session selection for the SQL Rally than they normally do for the annual summit.  Instead of a full program committee which selects sessions then announces them, they are leaving the session selection up to the community via a vote. ...


January 18, 2011  5:22 AM

My slide decks from #sqlsat62 in Tampa.



Posted by: Denny Cherry
Data Encryption, SQL Saturday, SQL Saturday 62, SQL Server, Storage

I gave two talks at the recent SQL Saturday 62 in Tampa, FL and I had a blast doing it.  As promised I've posted them on Monday (it is still Monday my time, so that counts right)?   Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 17, 2011  2:00 PM

How much cache to allocate for servers that host 500gb databases?



Posted by: Denny Cherry
Cache, SQL Server, Storage

The short answer is as much as possible. The more exact answer is you typically can’t allocate cache to a specific LUN.  You can usually carve up the total amount of cache into read and write cache.  You want as much write cache as possible so that the database writes directly to the disk as...


January 13, 2011  2:00 PM

What are your opinions on using an iSCSI NAS for SQL Server storage?



Posted by: Denny Cherry
iSCSI, SQL Server, Storage

You’ve really got two questions here.  The first is if I like iSCSI for SQL, and the second is if I like NAS for SQL.  NAS doesn’t support iSCSI as iSCSI is a SAN technology. iSCSI is just fine for SQL Server as long as the server and the storage are on the same subnet, and the network has...


January 10, 2011  2:00 PM

Donuts, Coffee, Lunch and an MVP for $99.



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

This great phrase (which is way more clever than anything I could come up with) was tweeted by Daniel Taylor (Twitter) last week while talking about the pre-cons which are coming up this week in Tampa. ...


January 6, 2011  2:00 PM

Lets get session state out of the database, and into memory where it belongs.



Posted by: Denny Cherry
Paul Randal, Session State, SQL Server

One of the all to common configuration mistakes that are made is to put the session state within the SQL Server when a website begins to scale to multiple web servers. Some background For those that don't know what session state is, let me take a step back and fill you in. ...


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: