Best Practices for SQL Server and Oracle

One common questions from the clients is what are the best practices for their environment and for their type of an application - the question could be from an architecture stand-point, it can be from the production stand-point or from a disaster recovery / maintenance stand-point. The right place to start from is to look at the respective Vendor’s site(s) to look at the best practices guidelines that are offered by those vendors. Here are some links that you should read more upon:

Microsoft SQL Server Best Practices:

http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

Oracle RDBMS Best Practices:

http://www.oracle.com/pls/db102/search?remark=quick_search&word=%22Best+Practice%22&tab_id=&format=ranked

http://www.oaug.org/resources/bestpractices.html

There are a lot of very good whitepapers, sample set-up scenarios, sample code etc. to demonstrate the best practices for different sections. These would help you to find the information that you need and see whether those best practices are being adhered to or not in your environment(s). Have fun