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()
For a WAIT FOR test in MySQL, I use SLEEP with a bounded delay. A customer asked for the corresponding command.
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.
How Blogging Has Changed: From Online Diaries to Newsletters
How blogging has changed is the story of one garden. It grew from online diaries and hand-built pages into blog software, feeds, short updates and newsletters. Through all of it, the useful, honest and regular post stayed the same.
SQL SERVER – List All Available TimeZone
sys.time_zone_info lists timezone names and their current offsets. My SQL Server 2019 environment returned 141 rows.