July 3, 2008 4:59 PM
Posted by: Denny Cherry
Back To Basics,
In Person EventsAt 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
Posted by: Denny Cherry
SQL Server 2005,
SQL Server 2008,
Windows 2008,
Windows FirewallI 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
Posted by: Denny Cherry
Attack Prevention,
Security,
SQL InjectionAn 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
Posted by: Denny Cherry
Back To Basics,
BEGIN DIALOG,
SEND,
Service Broker,
SQL,
T/SQLThe 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
Posted by: Denny Cherry
Disk Alignment,
Diskpar,
Diskpart,
SQL Server,
StorageMyself 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
Posted by: Denny Cherry
Back To Basics,
Route,
Service Broker,
SQLRoutes 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
Posted by: Denny Cherry
GeekSpeak,
SQL Server 2008,
WebcamFor those who were unable to attend my Geekspeak session last week the session was recorded and that
June 16, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Route,
Service,
Service Broker,
SQLServices 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
Posted by: Denny Cherry
Beta,
Migration,
SQL Server 2005,
SQL Server 2008,
SSISA 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...
