SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.
Exponential Backoff: How SQL Server Estimates Several Filters
The plan guessed 89 rows and 500 came back. Here is the rule behind that guess, and what to do about it.
SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016
When did you take your last database backup? Tim Radney shares a simple script that shows the last backup for all databases on a server.
Querying Nested JSON Arrays With OPENJSON
Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.
Indexing JSON Properties With Computed Columns
Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.
The Native JSON Data Type in SQL Server 2025
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.










