Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Strategies, Best and Worst Practices Rss

   Items 1 to 10 of 10   

Best Practices in an Adhoc Environment

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.   Read more...
By Sharad Nandwani 2003/12/16 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,913 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: | Category: installation
Rating: |  Discuss |   Briefcase | 8,977 reads

Worst Practice - Bad Comments

This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.   Read more...
By Andy Warren 2003/01/23 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,423 reads

Worst Practices - Making On-The-Fly Changes

Continuing with our worst practices series, Steve Jones looks at another administrative no-no. Making a change to your live system on the fly.   Read more...
By Steve Jones 2003/01/20 | Source: | Category: availability
Rating: |  Discuss |   Briefcase | 7,752 reads

Worst Practice - Not Having An Archive Plan For Each Table

We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?   Read more...
By Andy Warren 2002/11/11 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 9,168 reads

Worst Practices - Encrypting Data

Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.   Read more...
By Steve Jones 2002/01/08 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 8,401 reads

Worst Practices - Depending on the GUI

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?   Read more...
By Steve Jones 2001/12/04 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 6,216 reads

Worst Practices - Assigning Users Rights

Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.   Read more...
By Steve Jones 2001/11/06 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 7,222 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,415 reads

SQL Server Database Coding Conventions and Best Practices

Learn the key basics of writing quality Transact-SQL code.   Read more...
By Additional Articles 2001/09/07 | Source: Other | Category: naming standards
Rating:  Rate this |   Briefcase | 6,406 reads
   Items 1 to 10 of 10   
worst practices (6)    
sql server 7 (5)    
best practices (4)    
miscellaneous (4)    
security (4)    
database design (2)    
naming standards (2)    
administration (1)    
availability (1)    
installation (1)    
programming (1)    
stored procedures (1)    
system development life cycle (1)    
t-sql (1)