Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.
Detecting Memory Pressure – SQL in Sixty Seconds #186
After my video on CPU running 100%, many of you asked for one on memory. Here is my SQL in Sixty Seconds video on detecting memory pressure.
MySQL – Wait For Seconds Using SELECT SLEEP()
Recently my client asked me if there is the equivalent command of WAIT FOR of SQL Server in MySQL. Of course, there is and a very simple one.
Parquet Exports From SQL Server 2022 With CETAS
Build Parquet exports from SQL Server 2022 with PolyBase CETAS, S3-compatible storage, and checks for rows, types, and files.
IGNORE NULLS in SQL Server 2022: Carrying the Last Known Value Forward
Use IGNORE NULLS for forward-filled readings, find the next known value, and compare the older running-count grouping method carefully.
TOP N Sort: Why a Small TOP Still Reads the Whole Table
Explain TOP N Sort, compare an indexed ordered access path, and align filter and sort keys before adding indexes for frequent requests.
SQL Authority 15 Years of Blogging and Upcoming Changes
Today I complete my 15th year of blogging at SQLAuthority.com. I am truly honoured that many are reading my blog after 15 years.