Installing SQL Server on Windows Server 2008
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 here. Denny
New Article: Secure SQL Server from SQL injection attacks
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 developers point of view. Denny
SoCal Code Camp Slide Decks and Sample Code
As promised to the folks at the Code Camp here are the slide decks and sample code from this weekends code camp. Back To Basics: Getting Back To The Basics of SQL Server SQL Server 2008 Resource Governor What Do All These Undocumented Stored Procedures Do Storage for the DBA Virtual SQL Servers Should I […]
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, […]