Do you have a case where you have a named instance you'd like to migrate to a default instance? Is there pushback on doing so? Are there concerns that...
2026-09-07 (first published: 2026-08-26)
233 reads
A few months ago I started using Deepstash. Deepstash breaks books into the key ideas, usually 10-12 per book. If I am thinking about reading a book, I check...
2026-08-27
47 reads
Probably the best piece of advice I ever received is to take time to gain perspective.
2026-08-24 (first published: 2026-08-14)
338 reads
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...
2026-08-19 (first published: 2026-08-04)
358 reads
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...
2026-08-17 (first published: 2026-07-30)
403 reads
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in...
2026-08-12 (first published: 2026-07-29)
419 reads
I developed these rules a while back, before COVID. I had a period of self-reflection when I realized I was spending time wastefully arguing with folks on the various...
2026-08-12
150 reads
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's why you should read it if you're a DBA or security professional.
2026-08-11
281 reads
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin. When we are rejected, whatever the situation, many of us want to know why. We...
2026-08-10
267 reads
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included in that announcement were high level details about MDASH with MAI-Cyber-1-Flash, which is reported to...
2026-08-07 (first published: 2026-07-28)
358 reads
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers