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.

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

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

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.

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

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

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

Get tips for updating to Microsoft SQL Server 2014, including using SLQ's Copy Database Wizard and a checklist with key tasks to complete during your migration plan.