Check out these featured resources from SearchSQLServer.com.

    Requires Free Membership to View

SQL Server security: Step-by-Step Guide: How to patch SQL Server
So you've decided to secure your SQL Server infrastructure and you don't know where to start. This two-part guide will help you track down those pesky servers, then walk you through how to properly patch them.

SQL Server performance: SQL Server performance-tuning worst practices
Sometimes the best practices do not hit home, but the worst practices do. This article, by Jeremy Kadlec, addresses a number of the worst practices for SQL Server performance, with recommendations for correcting them and improving overall system performance.

SQL Server development: Triggers explained
A SearchSQLServer.com member asks expert Andrew Novick to explain how triggers work. Check out Andrew's answer and examples.

Database administration: Tech Topics: SQL Server backup and recovery
Visit our backup and recovery resources page where expert Greg Robidoux answers your toughest questions. While you're browsing, download the free chapter "Availability and recovery features" from the book Microsoft SQL Server 2005 New Features. Be sure to bookmark this section -- it's updated regularly.

This was first published in May 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.