SQL Server with Mr. Denny:

June, 2008


June 30, 2008  11:00 AM

New Article: Secure SQL Server from SQL injection attacks



Posted by: Denny Cherry
Attack Prevention, Security, SQL Injection

An article that I wrote about securing your SQL Server from SQL Injection attacks was just published.  It covers information from both a DBAs point of view and a .NET...

June 28, 2008  8:57 PM

SoCal Code Camp Slide Decks and Sample Code



Posted by: Denny Cherry
Code Camp, In Person Events

As promised to the folks at the Code Camp here are the slide decks and sample code from this weekends code camp.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 26, 2008  11:00 AM

Back To Basics: The SEND command (and the BEGIN DIALOG command)



Posted by: Denny Cherry
Back To Basics, BEGIN DIALOG, SEND, Service Broker, SQL, T/SQL

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...


June 25, 2008  9:27 PM

Comic Book Cover Contest



Posted by: Denny Cherry
Comic

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

Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 23, 2008  11:02 AM

How much performance are you loosing by not aligning your drives?



Posted by: Denny Cherry
Disk Alignment, Diskpar, Diskpart, SQL Server, Storage

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.  Before we can begin to figure this...


June 19, 2008  11:00 AM

Back To Basics: Service Broker Routes



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

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...


June 16, 2008  7:12 PM

Replay URL for my GeekSpeak Session



Posted by: Denny Cherry
GeekSpeak, SQL Server 2008, Webcam

For those who were unable to attend my Geekspeak session last week the session was recorded and that

Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 16, 2008  11:00 AM

Back To Basics: Service Broker Services



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

Services are used to bind contracts to queues.  They are also used to database to database, or server to server routing of messages via routes (we'll talk about them later).  Unlike most other objects within SQL Server, the name of the service is case sensitive, no matter what collation you have...


June 12, 2008  5:24 AM

Use caution when upgrading SQL 2008 CTP SSIS packages to RC0



Posted by: Denny Cherry
Beta, Migration, SQL Server 2005, SQL Server 2008, SSIS

A ran across a bit of a problem when upgrading my SQL 2008  CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0.  Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages.  Because of this when I edit all of the script tasks within my SSIS package the...


June 10, 2008  7:32 PM

SQL Server 2008 RC 0 Released



Posted by: Denny Cherry
SQL Server 2008

Microsoft has just released SQL Server 2008 RC 0.  This release should be pretty close to the final version expected out later this year. Denny


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: