SQL Server with Mr. Denny:

SQL Server


July 3, 2008  4:59 PM

My Back To Basics session was way more popular than I was expecting



Posted by: Denny Cherry
Back To Basics, In Person Events

At the last SoCal Code Camp I did several new sessions.  One of which was my Back To Basics session.  When I was setting up the session I figured that a few people would show, mostly because the wouldn't have anything else to do for the first session. What I got instead was a massive...

July 3, 2008  5:39 AM

Installing SQL Server on Windows Server 2008



Posted by: Denny Cherry
SQL Server 2005, SQL Server 2008, Windows 2008, Windows Firewall

I ran across an excellent post from Shawn Hernan of the SQL Server Development team (the guys that write SQL Server).  Shawn has put out an excellent blog post on what needs to be done to get SQL Server2005 or SQL Server 2008 installed on Windows Server 2008.  You can find the post


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