SQL Server with Mr. Denny:

February, 2011


February 28, 2011  2:00 PM

I’m having a sale on SQL Saturday slide decks, two for the price of one.

Denny Cherry Denny Cherry Profile: Denny Cherry

The last two weekends I've presented at two different SQL Saturday events, so as I'm pretty lazy I'm posting the decks for both weekends in a single blog post. SQL Saturday 47 - Phoenix

February 24, 2011  2:00 PM

ANSI Settings can have all the difference in the world.

Denny Cherry Denny Cherry Profile: Denny Cherry

So a little while back we noticed that we had some high CPU load coming from a single...


February 21, 2011  2:00 PM

If you see your replication log reader slow down for no reason, here’s some stuff to look at.

Denny Cherry Denny Cherry Profile: Denny Cherry

So a while back...


February 17, 2011  2:00 PM

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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.

Denny Cherry Denny Cherry Profile: Denny Cherry

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.

Denny Cherry Denny Cherry Profile: Denny Cherry

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

    0 Comments     RSS Feed     Email a friend


February 10, 2011  2:00 PM

SQL Service Broker isn’t going anywhere.

Denny Cherry Denny Cherry Profile: Denny Cherry

All to often when I give a SQL Service Broker presentation, or when I'm talking to people about it they want to know...


February 7, 2011  2:00 PM

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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

Denny Cherry Denny Cherry Profile: Denny Cherry

So I drug myself out of bed this morning to...


February 3, 2011  2:00 PM

My MCM Knowledge Exam Test Experience

Denny Cherry Denny Cherry Profile: Denny Cherry

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


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: