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

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

T-SQL Tips -- GO # and WHILE Loops Two quick tricks: populating a table with data quickly, and boosting performance with WHILE loops. By Joshua Jones 07/12/2010 While there are a great many books ...

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

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.

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.

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

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

A new wave of mass SQL injection attacks seen in mid-August to hit over half a million websites, including parts of Apple's site serves as a weighty reminder of the growing prevalence of mass ...