Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Best Practices Rss

   Items 1 to 6 of 6   
 

Enhancing the readability of your code: Table aliasing in sql

When writing SQL, picking good tables aliases can greatly enhance the readability of your code  Read more...
By Sylvia Moestl Vasilik 2009/05/07 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,828 reads

SQL Server 2000 Best Practices Analyzer Beta

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.   Read more...
By Additional Articles 2004/02/10 | Source: TechNet Blogs | Category: security
Rating:  Rate this |   Briefcase | 3,082 reads

SQL Server Upgrade Recommendations and Best Practices - Part 2

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.   Read more...
By Additional Articles 2003/06/30 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,920 reads

SQL Server DTS Best Practices

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.   Read more...
By Additional Articles 2003/06/24 | Source: Other | Category: dts
Rating:  Rate this |   Briefcase | 3,595 reads

SQL Server Upgrade Recommendations and Best Practices - Part 1

This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.   Read more...
By Jeremy Kadlec 2003/03/03 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 8,933 reads

SQL Server Security Best Practices

Learn how to secure your data by implementing SQL Server security best practices.   Read more...
By Additional Articles 2001/09/20 | Source: Other | Category: security
Rating:  Rate this |   Briefcase | 3,252 reads
   Items 1 to 6 of 6   
 
Tags
best and worst practices (5)    
security (2)    
strategies (2)    
administration (1)    
dts (1)    
installation (1)    
naming standards (1)    
sql server 2000 (1)    
sql server 2005 (1)    
system development life cycle (1)    
table aliases (1)    
writing readable code (1)