Using the Data API Builder–VS Live San Diego Resources
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: https://github.com/way0utwest/DAB-Experiments
2026-09-17
46 reads
Running a Local LLM On Your Laptop Resources
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It was a fun session and I’m glad a few people came up to ask questions....
2026-09-16
54 reads
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post...
2026-09-28 (first published: 2026-09-16)
318 reads
Why sys.fn_dblog Is Undocumented And Why It's Still There
Why sys.fn_dblog Is Undocumented And Why It's Still There
Why sys.fn_dblog Is Still Undocumented — And Still There
This article is about why things are the way...
2026-09-16
95 reads
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what kind of stories would come out of it.
The topic was simple:
That one SQL Server outage...
2026-09-25 (first published: 2026-09-15)
257 reads
A Last Minute Trip to the EU
My life has some crazy travel stretches for sure. Between speaking, office visits, customer trips, I can be on the road a lot. As it is, I’ve flown across...
2026-09-14
68 reads
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with edges, and uses greedy graph traversal to avoid comparing a query against every vector in...
2026-09-23 (first published: 2026-09-14)
209 reads
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
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-21 (first published: 2026-09-12)
327 reads
T-SQL Snapshot Backups on Availability Group Secondary Replicas
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-21 (first published: 2026-09-11)
203 reads
The Book of Redgate: Hours
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
85 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers