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 and Worst Practices Rss

   Items 1 to 14 of 14   
 

Worst Practice - Triggering External Events

Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger.   Read more...
By Steve Jones 2004/02/23 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 9,789 reads

Worst Practice - Adding a Column Without Thinking!

Adding a column is one of the simpler tasks you'll ever do as a DBA, yet danger lurks! All too often we add columns without going through some type of check list to make sure we're safe. What could adding a column break? You might be surprised!   Read more...
By Andy Warren 2004/02/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,858 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,062 reads

Worst Practice - Spaces in Object Names

We can only guess that someone somewhere put spaces in an object name that Andy works with and gave him the idea for this worst practice. Funny as the topic may sound, we agree - why make your lifer harder?   Read more...
By Andy Warren 2003/10/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,167 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,025 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,899 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,564 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,914 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: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,403 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,135 reads

Worst Practice - Sorting by Ordinal

If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!   Read more...
By Andy Warren 2002/10/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,379 reads

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...
By Neil Weicher 2002/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,561 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: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 8,377 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,230 reads
   Items 1 to 14 of 14   
 
Tags
worst practices (9)    
administration (7)    
best practices (5)    
miscellaneous (5)    
security (5)    
strategies (5)    
programming (3)    
t-sql (2)    
ado (1)    
configuring (1)    
dts (1)    
installation (1)    
naming standards (1)    
sql server 6.5 (1)    
stored procedures (1)    
system development life cycle (1)    
triggers (1)    
visual basic 6 (1)