SQL Server with Mr. Denny:

SQL Server


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 14, 2011  2:00 PM

My MCM Lab experience.



Posted by: Denny Cherry
Certifications, MCM, SQL Server, SQL Server 2008

So just in case you missed it, I took and passed the Microsoft MCM lab last Thursday.  Since I'm the first person to go through the test in the new format I wanted to put together some comments (as best I can thanks to NDAs). So the MCM gives you 6 hours to complete, and when you take it,...


February 11, 2011  2:21 PM

In honor of my receiving my MCM, Amazon has started selling “Securing SQL Server” on the Kindle.



Posted by: Denny Cherry
Amazon, Book, Securing SQL Server, SQL Server

OK, that's totally BS, but it sounds awesome doesn't it. But it is sort of true.  I was grabbing the URL for my book to send to someone today, and I noticed that the


February 10, 2011  2:00 PM

SQL Service Broker isn’t going anywhere.



Posted by: Denny Cherry
Service Broker, SQL Server, SQL Server 2005, SQL Server 2012

All to often when I give a SQL Service Broker presentation, or when I'm talking to people about it they want to know what the odds are that SQL Service Broker will be removed from the platform like how Notification Services was ripped from the product after just one release. So here's just some...


February 7, 2011  2:00 PM

If you aren’t doing backups, you aren’t doing your job.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database.  There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...


February 5, 2011  7:27 PM

As a birthday present to me, Amazon has started shipping “Securing SQL Server”.



Posted by: Denny Cherry
Amazon, Book, Sales Data, Sean McCown, Securing SQL Server, SQL Server

So I drug myself out of bed this morning to an email from Sean McGown (Blog | Blog | Twitter) saying that Amazon had just told him that they...


February 3, 2011  2:00 PM

My MCM Knowledge Exam Test Experience



Posted by: Denny Cherry
Certifications, MCM, SQL Server

As many of you know, I took the Microsoft Certified Master (MCM) knowledge exam back in November, and received notice that I passed back in December.  The MCM knowledge exam is the first of...


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 31, 2011  2:00 PM

East coast MVPs, we need your help at the west coast SQL Saturday’s.



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

OK, everyone it's time to come out west.  There are two SQL Saturday's scheduled for April 9th, 2011 here on the west coast.  Personally I'd love to see you all show up at our SQL Saturday event down here in Huntington Beach (Orange County,...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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: