Back To Basics: The SEND command (and the BEGIN DIALOG command)
The SEND command was introduced to SQL Server when SQL Server 2005 was released. It’s kind of like the INSERT command except that it is used only with the SQL Server Service Broker. With the service broker you put data into a queue instead of a table. Insert of inserting a command into the queue, […]
Comic Book Cover Contest
I know that this is way outside the normal content for my blog, but oh well. A friend at work has entered a comic book cover contest. Needless to say he’s very talented. His picture is below. The reason that I’m posting this is it’s a public voting contest, and he needs your help. The […]
How much performance are you loosing by not aligning your drives?
Myself and many other people have been saying for quite a while now that you need to align your disks before putting data on them. I know have some information on how you can figure out just how much potential performance you are loosing by not aligning.
Back To Basics: Service Broker Routes
Routes are only needed when sending service broker messages from one server to another. They define the SQL Server and TCP Port which the sending SQL Server will connect to in order to deliver the message. If you are sending the message to a mirrored database, then you can specify the mirror as well as […]