SQL Server with Mr. Denny:

May, 2008


May 19, 2008  8:03 AM

EMC World 2008 Day 0



Posted by: Denny Cherry
EMC, EMC World 2008, Family, In Person Events, Storage

Today is the check-in and welcome party for EMC World.  EMC and Brocade had the Goo Goo Dolls perform at the welcome party.  The party and show were fantastic. Funniest comment of...

May 15, 2008  11:00 AM

Back To Basics: Service Broker Message Types



Posted by: Denny Cherry
Back To Basics, Message Type, Service Broker, SQL

The message type is the first of the service broker specific objects.  The message type defines the name of the message, and performs any validation that the service broker needs to do on the contents of the message prior to sending the message.  If the message is being sent to another database...


May 14, 2008  8:00 AM

Any other DBAs brave enough to go to EMC World?



Posted by: Denny Cherry
Storage

Next week I'll be stepping into the lion's den of sorts.  I'll be off to Las Vegas to attend EMC World.  I went last year, and I'm pretty sure that I was about the only full time DBA there.  The storage folks treated me pretty nice, even after they found out that I was a DBA. Hopefully when I...


May 12, 2008  9:00 AM

Data Normalization, with storage being so cheap what’s the point?



Posted by: Denny Cherry
Data integrity, Data Normalization, SQL

Back in the old days one of the big reasons that people enforced such strict rules on data normalization was because it would greatly increase the amount of information you could fit on the hard drive.  Back when everything was measured in kilobytes or megabytes storing redundant information...


May 8, 2008  11:00 AM

Back To Basics: The SQL Server Service Broker



Posted by: Denny Cherry
Back To Basics, Service Broker, SQL

The SQL Server Service Broker is a fantastic new addition to SQL Server.  For those who have used Microsoft Message Queue (MSMQ) the service broker will be easy to understand as it's the same basic concept.  Messages are sent from one place to another, within a database, from database to...


May 8, 2008  4:04 AM

Quest Meet the Expert Video published



Posted by: Denny Cherry
Queue, Video

Quest Software has just published the first of a few videos which I recorded with them. You can download or view the video from here. I've...


May 5, 2008  9:00 AM

I’ll be speaking at the Inland Empire .Net User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


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: