Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your SQL Server Estate”. I’ll drop the recording into this post once it’s published. What I...
2026-09-14 (first published: 2026-09-04)
114 reads
A RAG pipeline that answers questions in the demo is not the same thing as a RAG pipeline that answers them correctly. The gap between the two only shows up...
2026-09-14 (first published: 2026-09-04)
77 reads
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2026-09-12
21 reads
How to Check TDE Progress and Elapsed Time in SQL Server
Transparent Data Encryption (TDE) protects SQL Server data and log files while they are stored...
2026-09-11
30 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual...
2026-09-11 (first published: 2026-09-02)
111 reads
I have said and written this many times: Redgate Software is the type of company I’d want to build if I founded another company. It’s a great place, and...
2026-09-11
30 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...
2026-09-11
16 reads
I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...
2026-09-11 (first published: 2026-09-02)
216 reads
How I used AI for this postChatGPT to generate images based on info specifically provided by me,including examples.Grammarly to catch grammar and sentence construction errors. I did a presentation...
2026-09-09 (first published: 2026-08-27)
173 reads
Most enterprise questions do not live neatly in one place. The numbers may be in a warehouse, the rules may be buried in PDF files, and the explanation may...
2026-09-09 (first published: 2026-09-03)
281 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers