While SQL Server automatically ensures the integrity of your data up to a point, it won't protect you from inept handling of transactions, or breaking internal referential integrity -- two of many things that can ruin the quality of your data. In this guide, Serdar Yegulalp discusses how to enforce and ensure data integrity on many fronts at once -- not just in your database maintenance habits, but also in programming, bounds checking and other realms that can be overlooked.
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 2005 Express
Along with the upcoming release of SQL Server 2005, Microsoft is introducing SQL Server Express -- a free version of SQL Server 2005. Serdar Yegulalp reviews the advantages and limitations of SQL Server Express in this tip.
Dig Deeper on SQL Server Database Modeling and Design
Related Q&A from Robyn Lorusso
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.