T-SQL 2 posts
Native backup of all databases in a Microsoft SQL database server

A T-SQL script to backup all non-system databases in a SQL Server instance in one go, with timestamped filenames.

SQL ServerT-SQLDatabaseBackup
1 min read
Importing IIS logs into MS SQL

Two approaches for importing IIS web server logs into Microsoft SQL Server for analysis — using native BULK INSERT or Microsoft's Log Parser utility.

IISSQL ServerT-SQLLog Analysis
1 min read