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.
CPU Running 100% – SQL in Sixty Seconds #185
I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.
SQL SERVER – Measure Index Performance
I measure index performance against the same workload before and after a change. A customer wanted to assess a new index.