SQL

Slide Decks and Sample Code from SoCal Code Camp

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...

Guide to Installing SQL 2000 and SQL 2005 on the same machine

You can install SQL 2000 and SQL 2005 on the same machine.  I always recommend that they be installed in this order to try and get everything working as best as possible.

1. Install SQL 2000
2. Install SQL 2005
3. Install SQL 2000 SP4 (Or the latest service...

Virtualizing SQL Server? When to and when not to.

Virtualizing servers is huge right now.  And thanks to VMWare it is very easy to build virtual machines.  In most of IT virtualizing servers is a good think.  In the database world, that isn't always the case.  As we know...

MS KB Article with all the hot fixes listed

I found this great little MS KB article today.  It's got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug.  The MS KB article ID is 937137. Denny

Log Shipping without SQL Server Enterprise Edition

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise Edition on both the machines.  This makes the solution fairly expensive.  Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...

SQL Server 2008 – Resource Governor Questions

The engineers from Microsoft PSS has posted some excellent information on thier blog about SQL Server 2008's Resource...

New Article: Determining SQL Server database storage requirements

I’ve published a new tip over on SearchSQLServer.com entitled “

January 10, 2008  8:00 AM

SQL CLR: The What, When, Why and How.

Posted by: Denny Cherry
CLR, Config, SQL

There are two camps when it comes to SQL CLR.  The DBA camp, which says don't use it, it'll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything.  These two different camps also represent the different messages which...

      0 Comments     RSS Feed     Email a friend

January 3, 2008  8:00 AM

Using a foreach loop to process an XML document.

Posted by: Denny Cherry
DataManagement, SQL, SQL Server 2005, SQL Server 2008, SSIS, XML

Receintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn't for the life of me get it to properly process the XML document which I...

      0 Comments     RSS Feed     Email a friend

December 27, 2007  8:00 AM

Avoiding SQL Injection Attacks

Posted by: Denny Cherry
Attack Prevention, Security, SQL, T/SQL

The most common way for people to insert invalid data or cause damage to your database is through what is called a SQL Injection Attack.  This is when malicious code is placed within the responses which are expected and that code is not caught and it instead executed.  Depending on what level of...

      0 Comments     RSS Feed     Email a friend