SQL Server 3 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
Enable Remote Connections to SQL Server 2008
Step-by-step guide to configuring SQL Server 2008 Express on Windows 7 to accept remote connections through Windows Firewall.
SQL ServerWindowsFirewallNetworking
1 min read