SQL Server How-to guides and examples

SQL Server Datatypes - Strings, integers, Unicode, binary data.
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.

dimTimes - Create a Time Dimension table.
dimDates - Create a Date Dimension table.
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


 
Copyright © 1999-2025 windevcluster.com
Some rights reserved