SQL Server with Mr. Denny:

January, 2008


January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

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

January 28, 2008  8:00 AM

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



Posted by: Denny Cherry
Installation, SQL, SQL Server 2000, SQL Server 2005

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


January 24, 2008  8:00 AM

Best way to get assistance on the messages boards.



Posted by: Denny Cherry
Assistance, Support, Tech support

There are literally thousands of different message boards on the Internet where you can find technical information from fellow IT professionals.  When asking questions on these boards there are some basic guidelines which most people like to have followed.  They are sometimes informal, but they...


January 21, 2008  8:00 AM

Virtualizing SQL Server? When to and when not to.



Posted by: Denny Cherry
SQL, Virtualization

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


January 17, 2008  12:00 PM

MS KB Article with all the hot fixes listed



Posted by: Denny Cherry
Article, Bug, SQL, SQL Server 2005, Support

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


January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition



Posted by: Denny Cherry
DR, Log Shipping, Replication, SQL, T/SQL

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


January 12, 2008  1:26 AM

SQL Server 2008 – Resource Governor Questions



Posted by: Denny Cherry
Resource Governor, SQL, SQL Server 2008

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

Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 11, 2008  6:40 PM

New Article: Determining SQL Server database storage requirements



Posted by: Denny Cherry
Article, Config, DataManagement, SQL, SQL Server 2005, SQL Server 2008

I’ve published a new tip over on SearchSQLServer.com entitled “   Bookmark and Share     0 Comments     RSS Feed     Email a friend


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


January 7, 2008  8:00 AM

XML in the database. What’s the big deal any way?



Posted by: Denny Cherry
Data Types, T/SQL, XML

So, we've had the ability to use XML within the SQL Server databases since SQL 2000 came out.  What's the big deal you ask?  How can I use it to make my life easier you also ask? When I first started looking into this whole XML thing I was thinking the same thing.  How is this blob of data...


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: