SQL Server with Mr. Denny:

SQL Server


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


September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication



Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...


September 11, 2008  11:00 AM

Service Broker may not remove messages after processing



Posted by: Denny Cherry
END CONVERSATION, Service Broker, SQL, SQL Server 2005, TempDB

I've seen an issue with Service Broker that others may be seeing.  Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue.  However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...


September 2, 2008  7:30 PM

Get SQL Server log shipping functionality without Enterprise Edition



Posted by: Denny Cherry
Article, Log Shipping, SQL Server 2000, SQL Server 2005, SQL Server 2008

A new tip of mine has just been published on SearchSQLServer.com.  This tip, "Get SQL Server log shipping functionality...

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: