A Tea Time chat at our India office turned into a debate on Quality Assurance vs Quality Control. Here is a simple way to tell QA and QC apart.
Writing Tests for Stored Procedures
Write tests for stored procedures with arrange, act, and assert steps in T-SQL, isolated data, and a repeatable check before every change.
SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
Can TRUNCATE be rolled back? Inside an open transaction yes, but once the session is closed TRUNCATE can’t be rolled back using log files, while DELETE can.
SQL SERVER – Mirrored Backup Introduction and Explanation
SQL Server 2005 Enterprise and Developer editions support mirrored backup: one BACKUP DATABASE command with MIRROR TO writes the same backup to two places.
SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links
Two of my articles on managing duplicate rows: how to count duplicate records and how to delete duplicate records in SQL Server tables.
SQL SERVER – Object Oriented Database Management Systems
Why I do not write about Object Oriented Database Management Systems, and a paper by Dare Obasanjo that explains OODBMS and its tradeoffs versus RDBMS.
Setting Up Database Mail for Alerts
Setting up Database Mail for alerts means creating an account and profile, testing delivery, linking Agent, and checking the queue when mail stops.
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.