When performance tuning your database server or database server environment.  It is important to look at tempdb growth settings.  When tempdb grows it halts server operations and in some cases this could be very costly.  Use the script provided below to query your database farm and then set the original size to something greater than

Read more…

Here is a SQL Server Security Checklist to help you get started SQL Injection Checks Check Description   Input passed to data access methods that originates outside the current trust boundary is constrained. Sanitization of input is only used as a defense in depth measure.   Stored procedures that accept parameters are used by data

Read more…