Called in to tune an OLTP server, I ended up helping a Jr. DBA whose restore kept failing. Here is the story of that corrupted backup file.
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
Two DISK targets in one BACKUP command split the file, they do not copy it. Learn how a mirrored database backup takes multiple backups in a single command.
Stored Totals: Find Drift Before Repairing It
Stored totals can drift from their authoritative line amounts. This private demonstration finds two mismatches, retains empty orders and accepts valid credits. It checks decimal range before a private repair and explains why concurrency needs separate proof.
DATE_BUCKET: Align 15-Minute Windows With an Origin
DATE_BUCKET uses an origin to align reporting windows. Keep width, unit and origin explicit while checking timestamps around each boundary.
SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it
TCP error code 10061 says the target machine actively refused the connection. In my StreamInsight app, a Windows Firewall exception for the port fixed it.
SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010
My SQL Server Performance Optimizations Seminar in Colombo on Oct 4-5, 2010 was a grand success, with 35 attendees and only one slide per hour.
SQL SERVER – Change Column DataTypes
A simple way to change column datatypes in SQL Server with ALTER TABLE ALTER COLUMN, shown on a sample table and checked with sp_help.