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 stored procedure in the Session State database.  This single procedure (TempUpdateStateItemLong) was taking up 80% of the CPU time that the database was using (we used Spotlight for SQL Server Enterprise from...

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 we were seeing some very strange behavior with our SQL Replication.  Every once and a while for no apparent reason the log reader would just slow down the pulling of records from a single publisher database.  Our replication was setup with a single publisher, and a single...

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

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

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 that I passed back in December.  The MCM knowledge exam is the first of...

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: