Requires Free Membership to View

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