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 ...

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 ...

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

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 ...

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

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.

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 ...