A follow up to my Remove Duplicate Chars From String post: Madhivanan shows how to remove duplicate characters from a string with a Number table approach.
SQL SERVER – Change Password of SA Login Using Management Studio
How to change password of SA login using Management Studio: log in with Windows Authentication, open the SA login properties, set the new password and test it.
SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC
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.