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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL SERVER – System Stored Procedure sys.sp_tables
Most people run SELECT * FROM sys.tables to list tables. If you do not need all those details, sys.sp_tables returns tables and views with schema names.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.