My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SUM DISTINCT: Equal Amounts Are Not Duplicate Rows
SUM DISTINCT totals different amounts without checking order identity. I’d establish the row grain first. Compare equal-priced orders, repeated copies and missing amounts.
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
SQL SERVER – Backup master Database Interval – master Database Best Practices
How often should you back up master? It holds logins and server settings, so here are my master database best practices for backup timing.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
Modulo: Negative Values Keep the Dividend Sign
Modulo can return a negative remainder for a negative dividend. A second expression normalizes a positive-divisor bucket while keeping the original input and remainder visible.
SQLAuthority News – Interview with SQL Server MVP Glenn Berry
My interview with SQL Server MVP Glenn Berry, Database Architect at NewsGator and longtime SQL Server teacher at University of Denver.
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.