SQL Server Datatypes - Strings, integers, Unicode, binary data.
Expressions - ALL, AND, ANY/SOME, BETWEEN, IN, LIKE, NOT, OR.
Field size recommendations for some common database fields.
Database Naming Convention.
Backup check - List SQL backups completed in the last 24 hours.
spRemoveLogin - Remove SQL logins.
Find the SQL Server Version and Service pack.
List SQL Instances (PowerShell).
List Compatibility mode for each database.
SQL Server RAM allocation.dimTimes - Create a Time Dimension table.
dimDates - Create a Date Dimension table.
Find the largest objects.
Trace Flags.
Transact-SQL reference
Links to other Sites, books etc
SQLCMD Command prompt utility for T-SQL .
SQL Server Version numbers