Vinod Kumar explains concurrency basics with a simple queue analogy: the shorter the line, the higher the concurrency, and how databases manage it with locks.
Rename a Column or Table in SQL Server Safely
To rename a column in SQL Server, call sp_rename with the table and column name, the new name and the word COLUMN. This post tests the rename on a demo database and shows what it leaves behind: a broken view, an old constraint name and permissions that stay. It ends with a safe way to swap two column names.
Storing UTC and Local Time Side by Side
Store UTC and local time consistently, preserve offsets, handle daylight saving changes, and filter timestamps with clear boundaries.
Change Logs as JSON: Old and New Values in One Column
Skip the audit table with a column for every field. One JSON payload per changed row is lighter, if you handle NULL and multirow updates correctly.
SQL SERVER – Changing Default Installation Path for SQL Server
Tired of moving MDF and LDF files after you create a database? Change the default installation path in server properties so new databases go where you want.
Recycling the Error Log on a Schedule and Keeping Enough History
Keep SQL Server logs readable by recycling the error log weekly, retaining enough archives, setting a size cap, and checking history.
SQLAuthority News – #SQLPASS 2012 Book Signing Photos
Book signing photos from SQLPASS 2012: launches of SQL 2012 Functions, SQL Queries 2012 Joes 2 Pros Volume 1 and Tim Radney’s SQL Backup and Recovery.
Checking Certificates That Expire Soon in Every Database
Nobody remembers who created that certificate. Here is a short loop that lists every certificate expiring soon, and what to ask about each one.
Window Functions Over GROUP BY Results: SUM of SUM Explained
Why does SUM(SUM(Amount)) OVER () work? Because the window runs after GROUP BY. A short demo with shares, ranks and a filter trap.
Ordering a Maintenance Window: Backups, CHECKDB and Index Work
Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.







.jpg)


