SQL Server with Mr. Denny:

SQL Server


November 6, 2008  11:00 AM

Very useful little query to monitor the health of service broker



Posted by: Denny Cherry
Service Broker, SQL Server 2005, SQL Server 2008, sys.conversation_endpoints

While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was.  So I came up with this little query which is surprisingly effective. select far_service

November 3, 2008  11:00 AM

Improving SQL Service Broker Performance



Posted by: Denny Cherry
END CONVERSATION, RECEIVE, Remus Rusanu, SEND, Service Broker, SQL Server 2005, SQL Server 2008, T/SQL

A while back I was talking to a Microsoft Support Engineer and he had mentioned that in a high load Service Broker environment such as ours there can be some impressive performance improvement can be achieved by reusing the service broker sessions. The cost of creating and closing a new...


October 28, 2008  12:57 AM

New SQL Server Wiki Launching Today



Posted by: Denny Cherry
Brent Ozar, Quest Software, SQLServerPedia.com

Today is the unofficial launch of the new SQLServerPedia.com Wiki.  The official launch for the wiki is during PASS, so you have to go...


October 25, 2008  11:00 AM

Slide Decks and Sample Code for SoCal Code Camp at USC



Posted by: Denny Cherry
Back To Basics, Federated Database, In Person Events, SoCal Code Camp, Storage

Here are the slide decks and sample code from my sessions at this weekends SoCal code camp.

  Bookmark and Share     4 Comments     RSS Feed     Email a friend


October 22, 2008  11:10 AM

Should I ask my boss to send me to PASS?



Posted by: Denny Cherry
PASS

I would say that yes you should. The PASS summit is an excellent learning opportunity that simply shouldn't be missed if you can't avoid it. No matter how much you think you know about SQL Server, there is always more to learn. I tend to think I know quite a bit about SQL Server and I enjoy...


October 16, 2008  11:00 AM

Handy Query to look at amount of data in Buffer Cache



Posted by: Denny Cherry
Cache, SQL Server 2005, SQL Server 2008, sys.allocation_units, sys.dm_os_buffer_descriptors, sys.partitions, sys.tables

Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache.  It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk. SELECT...


October 15, 2008  7:07 AM

Attending PASS 2008? Want a free MCP exam?



Posted by: Denny Cherry
Certifications, PASS

Microsoft and PASS have announced that you can take a free Microsoft Certification exam.  Visit the PASS Community Summit 2008 Microsoft Learning Certification Center Registration Site for...


October 6, 2008  8:33 AM

Orange County SQL Server User Group has started up



Posted by: Denny Cherry
In Person Events, Lynn Langit, Orange County SSUG, Service Broker, SQL Server 2005

Orange County now has its own SQL Server User Group.  It is being run as a part of the Orange County .NET Users Group.  The first speaker...


October 1, 2008  11:00 AM

T/SQL Code to remove SQL Injection Values from your tables



Posted by: Denny Cherry
SQL Injection, T/SQL

With SQL Injection Attacks being all the rage these days, I've been asked a couple of times for T/SQL code to clean up the database. So I threw this code together to clean up the data. This code will clean all the character and uni-code columns in all the user defined tables in the system. ...


September 30, 2008  6:58 PM

SQL Server consolidation: Why it’s an optimization technique



Posted by: Denny Cherry
Consolidation, SQL Server 2005, SQL Server 2008

This morning I released another tip on SearchSQLServer.com called "SQL Server consolidation: Why...

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: