Skip to content

10 Things You Shouldn’t Do with SQL Server

I’ve seen and written too much stuff that violates these rules. Click the link after “Via” for the full article…

10. Add a Low Privilege Account to the Admin Role
9. @@IDENTITY vs. SCOPE_IDENTITY
8. Fetch Semi-static Data on Each Request of a Resource
7. Include SQL Data Manipulation Language in Application Code
6. Abuse SELECT *
5. Create Stored Procedures without Exception Handling
4. Prefix Stored Procedures with “sp_”
3. You Don’t Protect the Database Connection String
2. Accept All Input
1. Access the Database from the Application with the “sa” Account

[Via dotnet junkies]