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.

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

Many of the tips covered in this blog post are related to the SQL*Plus set command. The currently configured value for a particular SQL*Plus variable can be displayed with the show command.

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

Enjoy faster SQL Follow these dos and don’ts whenever you can when writing queries or processes to improve your SQL performance, but remember to evaluate each situation individually to see which ...

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

Optimizing SQL Server performance is challenging work. And while you can find a lot of info on general performance problems, there hasn’t been much out there for tackling specific issues ...

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

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

SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them.