Technical Weblog of Eric Charran

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

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

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

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

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

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