Bill Vaughn provides a roundup of SQL Server 2008 indexing tips and tricks, based on advice form Kimberly Tripp and Paul Randall. The tips cover Query Optimizer selectivity and query optimization.

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress.

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots ...

Learn the things you need to know about SQL Server performance, and how these optimization tricks and strategies will help kick mediocre SQL performance to new heights. Get the paper today.

Know your SQL Server database KPIs A DBA is frequently challenged on how to improve, optimize, and maintain the performance of SQL server databases. SQL performance tuning is one of many ways to ...

Q&A Denny Cherry's Top Tips for Indexing SQL Server Tables A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing. By Becky Nagel 10 ...

Tricks for Processing SQL Scripts Discover how SQL Server 2005's SQLCMD tool can enhance your scripting processes. by Josef Finsel May 1, 2006 S QL Server 2005's Management Studio offers lots of new ...

Looking at SQL server 2005 upgrade? Learn how to save on our SQL server licensing costs with Microsoft SQL server 2014.

SQL injection attacks have been the bread and butter of system crackers since the first SQL database became Web-enabled. Here, the Channel Test Center offers a step-by-step strategy for blocking them.

When it comes to assigning value to different components in today's IT environment, it would be a serious mistake to underestimate the value of data and databases. Whether you are looking to reduce ...