SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Best Practices Rss

   Items 1 to 20 of 45    Older >>
 

8 practices for business data security

Is your data vulnerable to security breaches? Sophie Ross at Security Gladiators provides 8 rules you should be adhering to to ensure the safety of your data.  Read more...
By 2018/09/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,340 reads

SQL Crossword - Best Practices

This crossword tests your knowledge of SQL Server best practices.  Read more...
By Kenneth Fisher 2018/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

SQL Server Reporting Services General Best Practices

Ghanesh Prasad discusses 12 best practices any developer or DBA should follow when working on a SSRS project.  Read more...
By Additional Articles 2015/11/04 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,917 reads

The Zen of Code Reviews: Best Practices

If you don't feel that you are getting helpful and comprehensive feedback from code reviews, it may well be your fault. Unless you are considerate to your reviewers in a number of ways, they might find it difficult to check your code and provide helpful advice. What ways? Michael Sorens outlines the eight golden rules that, if you follow them, might even even make your code a pleasure to review!  Read more...
By Additional Articles 2015/09/15 | Source: SimpleTalk | Category: code review
Rating: (not yet rated)  Rate this |   Briefcase | 6,833 reads

PCI Best Practices Guide for SQL Server DBAs

Tibor Nagy has put together some best practices to help SQL Server DBAs navigate the many different requirements around PCI compliance.  Read more...
By Additional Articles 2015/05/21 | Source: MSSQLTips.com | Category: best practices
Rating: (not yet rated)  Rate this |   Briefcase | 6,810 reads

Getting the Most out of Statistics

Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!  Read more...
By Edward Pollack 2014/06/09 | Source: SQLServerCentral.com | Category: statistics (data)
Rating: |  Discuss |   Briefcase | 5,248 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 128,498 reads

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.   Read more...
By Additional Articles 2013/11/28 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 6,728 reads

Disk Is Cheap! ORLY?

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,635 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 128,498 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 128,498 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 128,498 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,341 reads

9 Things to Do When You Inherit a Database

Some tips on what to do when you inherit a database that you've never worked on before   Read more...
By Sylvia Moestl Vasilik 2012/06/15 (first published: 2009/06/22) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 53,912 reads

Where Do You Go for Authoritative SQL Server Best Practices?

There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.   Read more...
By Brad McGehee 2011/06/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 438 reads

Disk Is Cheap! ORLY?

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,635 reads

9 Things to Do When You Inherit a Database

Some tips on what to do when you inherit a database that you've never worked on before   Read more...
By Sylvia Moestl Vasilik 2012/06/15 (first published: 2009/06/22) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 53,912 reads

SQL Server Integration Services (SSIS) - Design Best Practices

In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1, Part 2 and Part 3) of this series I briefly talked about SSIS and few of the best practices to consider while designing SSIS packages. Continuing on this path I am going to discuss some more best practices of SSIS package design, how you can use lookup transformations and what considerations you need to take, the impact of implicit type cast in SSIS, changes in SSIS 2008 internal system tables and stored procedures and finally some general guidelines.  Read more...
By Steve Jones 2009/12/14 | Source: MSSQLTips.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 5,616 reads

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses

Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.  Read more...
By Additional Articles 2009/11/04 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,638 reads

SQL Server Integration Services (SSIS) Performance Best Practices

This tip is going to cover recommendations related to the SQL Server Destination Adapter, asynchronous transformations, DefaultBufferMaxSize and DefaultBufferMaxRows, BufferTempStoragePath and BLOBTempStoragePath as well as the DelayValidation property.  Read more...
Rating:  Rate this |   Briefcase | 5,884 reads
   Items 1 to 20 of 45    Older >>
 
Tags
best and worst practices (12)    
sql server 7 (6)    
t-sql (6)    
strategies (4)    
database design (3)    
integration services (ssis) (3)    
security (3)    
administration (2)    
data warehousing (2)    
editorial (2)    
miscellaneous (2)    
naming standards (2)    
capacity planning (1)    
code review (1)    
coding standards (1)    
credit card numbers (1)    
csv (1)    
data compression (1)    
data security (1)    
database mirroring (1)    
database weekly (1)    
data-modeling (1)    
datatypes (1)    
dba (1)    
delimited data (1)    
dts (1)    
execution plans (1)    
installation (1)    
nightly jobs (1)    
performance (1)    
performance tuning (1)    
puzzle (1)    
query optimizer (1)    
reporting services (ssrs) (1)    
scalar udf (1)    
sql server 2000 (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server agent (1)    
sql server reporting services (1)    
sqlservercentral (1)    
statistics (data) (1)    
system development life cycle (1)    
system tables (1)    
table aliases (1)    
writing readable code (1)