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

Articles with tag best practices Rss

Search for any content tagged best practices

<< Newer    Items 21 to 39 of 39   
 

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 | 109,735 reads

Tutorial: SSIS best practices

Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,591 reads

Best Practices for Data Warehousing with SQL Server 2008

There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.  Read more...
By Additional Articles 2008/09/12 | Source: TechNet Blogs | Category: best practices
Rating:  Rate this |   Briefcase | 4,585 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 | 109,735 reads

Best Practices when performing maintenance in a DBM environment

If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:  Read more...
By Additional Articles 2008/03/27 | Source: SQL Community | Category: database mirroring
Rating:  Rate this |   Briefcase | 1,911 reads

More RBAR and "Tuning" UPDATEs

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...
By Jeff Moden 2008/03/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,598 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 | 109,735 reads

Data Warehouse Quality Assurance Best Practices

Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse.   Read more...
By Additional Articles 2007/10/02 | Source: Datawarehouse.com | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 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,045 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,766 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,905 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,886 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,540 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,764 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

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,903 reads

SQL Server Best Practices web seminar offered by NetIQ

Join NetIQ on July 17, 2002 for a free web seminar on "SQL Server Best Practices -- Tools and Techniques for Improving Production Operations". The event is being offered three times at 9:00 AM ET, 12:00 Noon ET, and 4:00 PM ET.   Read more...
By Additional Articles 2002/07/17 | Source: Other | Category: best practices
Rating:  Rate this |   Briefcase | 1,411 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,213 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,124 reads
<< Newer    Items 21 to 39 of 39