SQL Server with Mr. Denny:

SQL


October 10, 2008  11:06 AM

My blogs 1 year birthday

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Well today is the one year birthday of my blog.  It's been a very fun and exciting year.  Here's hoping that the next year will be just as fun.  Denny Bookmark and Share     2 Comments     RSS Feed     Email a friend

October 8, 2008  1:12 AM

We just moved into our new office in Marina Del Rey, and the view is great.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The company I work for just finished our office move into our newer slightly larger office.  I've managed to snag myself a Window seat this time around.  I just wanted to share the view with everyone.  This is the view out my desk window.


October 6, 2008  8:33 AM

Orange County SQL Server User Group has started up

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Orange County now has its own


October 1, 2008  11:00 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

With SQL Injection Attacks being all the rage these days, I've been asked a...


September 30, 2008  6:58 PM

SQL Server consolidation: Why it’s an optimization technique

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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 25, 2008  11:00 AM

A Load Balanced Federated Database Solution

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

If you have a very high load on your database, but no specifically massive tables you may want to look into a fully load balanced solution for your database. This solution falls somewhere between your normal replication solution, and a federation solution. It’s not truly a federation as no one...


September 22, 2008  11:00 AM

The full replication federation

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Another type of database federation is what I call the full replication federation. This is where you place all the dimension tables...


September 19, 2008  7:04 PM

Great Turnout At the San Diego SQL Server Users Group Last Night

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I'd like to say thanks to the


September 18, 2008  11:00 AM

The Pyramid Federation

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

There are several techniques which can be used to federate your database. The first of which, which we will be talking about is the Pyramid Federation (I have no idea if that what it’s actually called, but that what I’ve named it). In a pyramid federation we have a single server which holds...


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: