5 free SQL Server tools

In the 10th Anniversary edition of SQL Server Magazine, there are recommendations to 5 free tools for SQL Server. Two of them are for load testing and the others for preventing SQL Injection -
  1. SQLQueryStress - query load testing tool written by SQL Server MVP Adam Machanic.
  2. SQL Load Generator - run multiple concurrent queries against SQL Server
  3. HP Scrawlr — This free scanner utility can detect and identify whether your website is susceptible to an SQL injection attack.
  4. URLScan — This security tool actively restricts the kind of HTTP requests that Microsoft IIS will process.
  5. Microsoft Source Code Analyzer for SQL Injection — Static code analysis tool for finding SQL Injection vulnerabilities in ASP code
The following are Kalen Delaney's recommendations for testing before deployment:
1. Test with real data.
2. Test with real data volumes.
3. Test with a real number of concurrent users.

Also see:
SQL Server Performance Audit Checklist
Tips on ASP.NET Hosting & Deployment

Comments