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

Content with tag Best and Worst Practices Rss

   Items 1 to 20 of 32    Older >>
 

Checking Up on Developers

This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.  Read more...
By Steve Jones 2013/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 484 reads

REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter

This white paper explains how Microsoft® adCenter implemented a Microsoft SQL Server® 2008 Analysis Services Scalable Shared Database on EMC® Symmetrix VMAX™ storage. Leveraging TimeFinder® clones and Enterprise Flash Drives with the read-only feature of SQL Server 2008 Analysis Services allowed adCenter to dramatically scale out OLAP while maintaining SLAs and decreasing system outages.   Read more...
By Additional Articles 2011/06/08 | Source: SQLCAT | Category: best and worst practices
Rating: (not yet rated)  Rate this |   Briefcase | 2,125 reads

T-SQL Best Practices

This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.  Read more...
By Additional Articles 2009/07/24 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,477 reads

Checking Up on Developers

This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.  Read more...
By Steve Jones 2013/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 484 reads

Checking Up on Developers

This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.  Read more...
By Steve Jones 2009/05/01 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 273 reads

Checking Up on Developers

This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.  Read more...
By Steve Jones 2009/04/30 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 328 reads

Checking Up on Developers

This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.  Read more...
By Steve Jones 2009/04/30 | Source: SQLServerCentral.com | Category: best and worst practices
Rating: (not yet rated)  Rate this |   Briefcase | 250 reads

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,803 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,860 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,081 reads

Two Best Practices!

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!   Read more...
By Darwin Hatheway 2003/12/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,789 reads

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: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,908 reads

Worst Practice - Defining Rows that Exceed The Max Length

Andy started writing about worst practices a long time ago and returns this week with one that is short and sweet - why defining rows that exceed 8060 characters is a very bad idea and how you can avoid it.   Read more...
By Andy Warren 2003/12/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,724 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,171 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,042 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,916 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,591 reads

Free Webcast Today: SQL Server Security Best Practices

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.  Read more...
By Brian Knight 2003/04/02 | Source: TechNet Blogs | Category: best practices
Rating:  Rate this |   Briefcase | 1,793 reads

Worst Practices - Blank Passwords

Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.   Read more...
By Steve Jones 2003/03/31 | Source: SQLServerCentral.com | Category: worst practices
Rating: |  Discuss |   Briefcase | 5,355 reads

Free Webcast: SQL Server 2000 Security Best Practices

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.  Read more...
By Additional Articles 2003/03/27 | Source: TechNet Blogs | Category: best practices
Rating: |  Discuss |   Briefcase | 345 reads
   Items 1 to 20 of 32    Older >>
 
Tags
sql server 7 (14)    
worst practices (14)    
best practices (12)    
strategies (10)    
miscellaneous (8)    
administration (7)    
security (7)    
t-sql (4)    
database design (3)    
programming (3)    
naming standards (2)    
ado (1)    
analysis services (ssas) (1)    
availability (1)    
configuring (1)    
dts (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
installation (1)    
microsoft (1)    
sql server 6.5 (1)    
stored procedures (1)    
system development life cycle (1)    
triggers (1)    
visual basic 6 (1)