Top 10 SQL Server tips of 2005

We've tallied the top 10 SQL Server tips of 2005 according to your visits. While SQL Server 2005 introductions piqued your interest, it's tips on those nagging and troublesome administration basics that garnered the most attention. View the top 10 below or check out our complete tips collection.

#1 - Restoring a database from another SQL Server
Restoring a database from another SQL Server is simple -- matching up the logins and users again is not. Get the steps you need to restore one database from another in this tip.

#2 - Hacker's-eye view of SQL Server
This tip outlines the four primary methods used to hack into SQL Server and offers defenses to prevent such security breaches.

#3 - SQL Server performance-tuning worst practices
This tip addresses a number of the worst practices for SQL Server performance, with recommendations for correcting these practices and improving overall system performance.

#4 - Selecting a SQL Server recovery model
SQL Server 2000 offers three recovery models: Full Recovery, Simple Recovery and Bulk-Logged Recovery. This tip explains how to choose the best one for your needs.

#5 - Selecting a SQL Server backup model
This tip looks at several components to help define a backup strategy as well as the different backup options that are available in SQL Server 2000.

#6 - Stored procedure: List database objects by selected type(s)
Here's a simple stored procedure to return a list of all the objects of selected types in the current database.

#7 - Top 10 new features in SQL Server 2005
From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond. Learn about key enhancements in this tip.

#8 - 15 SQL Server replication tips in 15 minutes
This list of quick tips and tricks will help you enhance your replication techniques. It is broken up into three groups: performance, monitoring and miscellaneous.

#9 - Maintenance checks for SQL Server
SQL Server's maintenance plan wizard can automate all maintenance tasks for you -- but beware what's really going on behind the scenes. This list of activities will help keep your SQL Server up to par.

#10 - SQL Server backup and restore, part I: The basics
This indepth tip analyzes the various options available for your backup and recovery process with SQL Server 2000.