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,...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
Dig Deeper on Microsoft SQL Server Tools and Utilities
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.