Use the JSON data type in SQL Server 2025, reject invalid documents, read and change properties, and choose where relational columns fit.
Time Zone Name in MySQL: How to Detect the Current One
Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.
SQL SERVER – Get Current TimeZone Name in SQL Server
What is the current TimeZone of the server where SQL Server is installed? Here is the short xp_regread script I use to read it.
MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME
Confused about TIMESTAMP or DATETIME in MySQL? I explain the two factors, starting with supported range, that help you decide which one to use.
SQL SERVER – Expanding Your Skills – Notes from the Field #015
Busy day job but want to grow your career? Brian Kelley shares his advice on expanding your skills and keeping up with new technology.
Storing Hash Values: binary(32) or a 64-Character Hex String
A hex string is just a printed hash, and it costs twice the space. Here is the round trip, the index sizes and the traps.
Page Restore: Fixing a Few Corrupt Pages Without a Full Restore
Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.