October 2005 - Posts
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
