SQLWebpedia

The SQLCAT team has a top ten list of OLTP performance issues: http://sqlcat.com/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx

Summary

The SQLCAT team has posted some good information about seldom used tools that should be of interest to many us: http://sqlcat.com/top10lists/archive/2007/11/21/top-10-hidden-gems-in-sql-server-2005.aspx

Summary

Typically, Systems Engineering group or another IT group will setup your server for you. If you are a one man team in this affair, I will assume you have installed Windows 2003 standard or enterprise edition and have it running with minimal services.

SQL Server settings can be tempting to use, but should be used with much caution; do research and test if it actually does improve performance in your case. I often limit the amount of memory sql server has available to it when I am using over 8GB of RAM. For these situations, I limit RAM to Total RAM - 2GB for the OS to use. e.g. 16GB of Total RAM I set to 14GB of Max RAM.

I didn't think this day would come, but I welcome it. Microsoft with Zend and community input is developing a SQL driver for PHP! Read more here: http://www.microsoft.com/sql/technologies/php/default.mspx

I sometimes come across great free tools from companies or individuals and I just wanted to share them in one convenient location.Last updated 8/2/2010 - Chuck Lathrope

I was talking with my friend the other day who works for a medical device manufacturer about his companies fear of clustered servers. His peers and managers have the opinion that clustered servers are hard to maintain, including long a frequent maintenance periods and are difficult to support.

I have commonly worked with companies that use active-passive clusters for high-availability. Clustering is a good idea, but with active-passive clusters, one cluster is sitting idley waiting for failure of the other server. This is an expensive proposition in typical enterprise environments. This is not true in active-active clusters.

In an active-active cluster, both servers are in use. They provide hardware and OS failover for eachother. Clustering is at the server and OS level and doesn't provide data redundancy, just server redundancy.

The official drupal site is http://www.drupal.org I have tested and used Joomla and Dot Net Nuke, but have always been left wanting. Drupal has superior categorization capabilities that I have been looking for. If you are looking to host a site similar to this, send me an email, as I need help and content authors will get a split of the ad revenue generated from their pages. Email me at gmail, use my alias.