Upgrade to the RTM Bits for SQL Server 2005

Like Silk.  I had an instance of the full imprint of SQL Server 2000 SP4 (Database Engine, Analysis Services, Reporting Services, etc.).  I just ran through the setup and it worked wonderfully.  It detected the installed products and versions and asked me what I wanted to do with them.   When attempting to upgrade, select the…

0

SQL Server 2000 Clustering Gotchas

Part 2 on AWE Memory If AWE is enabled, SQL Server cannot use the paging file If AWE is enabled, SQL Server will grab all memory it is allowed if the max server memory configuration option is not set.  If you accidentally forget to set this, SQL Server will attempt to grab all memory on…

0

SQL Server 2000 Clustering Gotchas

Yes, I know that SQL Server 2005 is on the horizon.  However, there are still many companies that are interested in clustering on SQL Server 2000.  As a result, here are some of the most prevalent gotchas when attempting to cluster.  These tips are from the ultimate guide to SQL Server 2000 clustering found here…

1

SQL Server Data Import Best Practices

The following link goes to an MSDN article which outlines some of the do’s and don’ts surrounding importing of data.  Whether its for a Data Warehouse or for import into a transactional applcation, these best practices are lessons learned from the best.  Follow Them!  They really will help you in the future, even if you…

0

Using Try Catch in SQL Server 2005

The try catch structure in SQL Server 2005 is one of the best additions to the TSQL language.  This allows for true error trapping and hadling as opposed to inspecting the @@ERROR variable in the rollback section of a transaction.  The syntax and structure for a TSQL try catch is as follows:BEGIN TRANSACTIONBEGIN TRY   INSERT…

1

Renaming A SQL Server 2005 Server

For all of you who remember the agony (well, not really agony, but extra steps) involved when renaming a machine with SQL Server 2000 on it, fear not.  I just installed SQL Server 2005 on a virtual machine (August CTP).  I realized that the virtual machine was a template and that I had not renamed…

1

Factory Design Pattern

 Usually, I wait a bit before consuming and championing a design an architecture principle to see how widespread it becomes and how others have implemented it successfully.  Coupled with my own research, I then usually throw my hat in the ring and come on board with the methodology, or decide to wait to evaluate it…

0

Inaugural Blog Entry – My Name Up In Lights!

Wow.  I never thought I’d see the day I’d have my own MSDN Blog.  I recently joined Microsoft as a Senior Consultant in the East Region and I’m looking forward to many adventures and challenges implementing Microsoft products, methodologies and technolgies to businesses.  I’m very pleased to have the opportunity to provide my experience and…

2