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...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

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...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Learn how to secure your data by implementing SQL Server security best practices.   Read more...

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...

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...