Use read-only queries for comparing two schemas, finding missing columns, checking type details, and reviewing indexes and modules.
SQL Server: Why Retrying an INSERT Can Create Duplicate Rows
Retrying an INSERT can create duplicate rows even with an identity primary key. These tested examples use a stable request ID to return the original order, reject changed inputs, and preserve unrelated errors.
GDR or CU: Choosing Your Update Branch
Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.
SQL SERVER – How to Get SQL Server Restart Notification?
Want a restart notification when SQL Server starts, without buying a tool? Here are the steps to run a stored procedure at startup.
SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.
Attach a Database in SQL Server and Detach It Safely
To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.
BACKUP WITH CHECKSUM: What It Checks and What It Cannot
Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.
Point-in-Time Restore: Getting Back Rows Deleted by Accident
Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.
Column Aliases: Where You Can Use Them and Where You Cannot
Why does WHERE say the alias does not exist? Here is the order SQL Server follows, two clean fixes and one quiet trap to avoid.
MySQL – Introduction to CONCAT and CONCAT_WS functions
MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.










