SQL Server with Mr. Denny:

Security


August 18, 2011  4:30 PM

When working with SQL in a cluster, the account rights on both nodes of the cluster need to be the same



Posted by: Denny Cherry
Clustering, Database, Permissions, Security, SQL Server

Recently I was working with a clients SQL Server cluster.  The managed service provide had installed some Windows patches causing the SQL Cluster to fail over to the other node.  No big deal, everything appeared to be working as normal.

After a couple of days we noticed...

July 28, 2011  2:00 PM

HA vs DR, what’s it all mean



Posted by: Denny Cherry
AlwaysOn, DR, SQL Server, SQL Server 11, Storage

People often get HA (High Availability) and DR (Disaster Recovery) mixed up.  There are a couple of reasons that this happens.  First is the fact that there aren’t any clear guidelines which separate the two.  There are standard terms which are used to help define HA and DR, but there’s...


June 15, 2011  5:27 PM

It’s #sqlpass summit session announcement time



Posted by: Denny Cherry
BI, Encryption, SQL PASS, SQL PASS 2011, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSAS, Stacia Misner

So I've managed to trick the kind folks of the SQL PASS program committee once again this year.  I've gotten two sessions accepted for the summit. The first is a "regular session" which is the normal 75 minute community session during which I'll be presenting "Where should I be encrypting my...


June 14, 2011  2:21 AM

Auto Close, Contained Databases and DDoS



Posted by: Denny Cherry
Attack Prevention, Consolidation, SQL Server, SQL Server 11

One of the features which has been announced to be coming in SQL Server “Denali” is the “Contained Database” feature.  The feature which I’m looking for the...


April 25, 2011  2:00 PM

We get many warnings in our SQL error log about I/O requests taking longer than 15 seconds to complete. What do we do in such scenario?



Posted by: Denny Cherry
Index, Index Scan, Index Seek, SQL Server, Storage

There are a few things which you will want to look at.  First make sure that you have enough RAM for the database to use.  Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...


February 17, 2011  2:00 PM

For the love of god people, quit screwing around with the base permissions within SQL Server.



Posted by: Denny Cherry
Database security, SQL Server, SQL Server 2000, SQL Server 2005

I know that security people like to remove permissions from everything before certifying that a server is ready to go into production.  And like 10+ years ago that was something that you might have wanted to do (I'm just talking about SQL Server here).  However in today's world of SQL Server 2005...


February 1, 2011  6:19 PM

Save 50% on my book “Securing SQL Server” Feb 1, 2011 only.



Posted by: Denny Cherry
Book, Database security, Discount Code, Securing SQL Server, SQL Server

Syngress, my publisher, is doing a one day sale for my book Securing SQL Server.  If you order from them directly and use discount code 50170 you'll get 50% off the price, bringing the price down to just $24.98.  Just click through to the Syngress


February 1, 2011  2:00 PM

My SoCal Code Camp slide decks



Posted by: Denny Cherry
Data Encryption, Encryption, In Person Events, Indexing, SoCal Code Camp, SQL Server, SQL Server 11, SQL Server 2012

So this last weekend was the 13th SoCal Code Camp (the 6th at this location).  I presented three different sessions at this code camp.  My slide decks can be downloaded below.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


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


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: