http://www.sqlservercentral.com/Content tagged Best Practices posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:http://www.sqlservercentral.com/redirect/articles/62572/2008/03/27http://www.sqlservercentral.com/redirect/articles/62572/Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/SQL Server expert Jeff Moden discusses a common problem seen in many update statements.http://www.sqlservercentral.com/articles/Performance+Tuning/62278/2008/03/14http://www.sqlservercentral.com/articles/Performance+Tuning/62278/Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.http://www.sqlservercentral.com/articles/Best+Practices/61537/2008/06/23http://www.sqlservercentral.com/articles/Best+Practices/61537/Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse. http://www.sqlservercentral.com/redirect/articles/61195/2007/10/02http://www.sqlservercentral.com/redirect/articles/61195/Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think. http://www.sqlservercentral.com/redirect/articles/1262/2004/02/10http://www.sqlservercentral.com/redirect/articles/1262/This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff! http://www.sqlservercentral.com/articles/Miscellaneous/twobestpractices/1229/2003/12/17http://www.sqlservercentral.com/articles/Miscellaneous/twobestpractices/1229/This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it. http://www.sqlservercentral.com/articles/Miscellaneous/bestpracticesinanadhocenvironment/1228/2003/12/16http://www.sqlservercentral.com/articles/Miscellaneous/bestpracticesinanadhocenvironment/1228/This article, Part 2 – SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture, will begin to detail the technical components faced by the DBAs and Developers during the Upgrade process. The technical components detail the Critical Upgrade Decisions related to ANSI NULLS, Quoted Identifiers and other items. http://www.sqlservercentral.com/redirect/articles/1038/2003/06/30http://www.sqlservercentral.com/redirect/articles/1038/This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources. http://www.sqlservercentral.com/redirect/articles/1013/2003/06/24http://www.sqlservercentral.com/redirect/articles/1013/Join SQLServerCentral.com co-founder Brian Knight for this free webcast on SQL Server security best practices. In this session on Technet, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.http://www.sqlservercentral.com/redirect/articles/953/2003/04/02http://www.sqlservercentral.com/redirect/articles/953/Join SQLServerCentral.com co-founder for this free webcast on SQL Server security best practices. In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.http://www.sqlservercentral.com/articles/Best+Practices/948/2003/03/27http://www.sqlservercentral.com/articles/Best+Practices/948/This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective. http://www.sqlservercentral.com/articles/Installation/sqlserverupgrade/930/2003/03/03http://www.sqlservercentral.com/articles/Installation/sqlserverupgrade/930/Join NetIQ on July 17, 2002 for a free web seminar on "SQL Server Best Practices -- Tools and Techniques for Improving Production Operations". The event is being offered three times at 9:00 AM ET, 12:00 Noon ET, and 4:00 PM ET. http://www.sqlservercentral.com/redirect/articles/728/2002/07/17http://www.sqlservercentral.com/redirect/articles/728/Learn how to secure your data by implementing SQL Server security best practices. http://www.sqlservercentral.com/redirect/articles/437/2001/09/20http://www.sqlservercentral.com/redirect/articles/437/Learn the key basics of writing quality Transact-SQL code. http://www.sqlservercentral.com/redirect/articles/393/2001/09/07http://www.sqlservercentral.com/redirect/articles/393/