Length and data type for some common database fields. dimTimes Create a Time Dimension table. dimDates Create a Date Dimension table. Backup check - list SQL backups completed in the last 24 hours. SQL Server & Oracle Versions and features. spRemoveLogin remove SQL logins. SQL Server Version and Service pack. List SQL Instances (PowerShell) List Compatibility mode for each database. Find the largest objects. Trace Flags.
Related
Transact-SQL reference Links to other Sites, books etc... SQLCMD Command prompt utility for T-SQL SQL Server Version numbers