Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.