Monday Monitor Tips: AI Query Analysis
AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....
2026-03-09
45 reads
Bind Variables – Worse than you were told
Many of you probably know Martin Bach. He’s a colleague here at Oracle although we’ve both been good mates in the Oracle community long before either of us joined...
2026-03-09
72 reads
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector databases — all comes together here! What is RAG? all the AI model has predefined...
2026-03-09 (first published: 2026-03-08)
45 reads
AI: Blog a Day – Day 7: Vector and Vector Databases
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...
2026-03-23 (first published: 2026-03-07)
379 reads
AI: Blog a Day – Day 6: Embeddings – How AI Understands
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now Day 6 is inside of AI , how AI understand us, as computer do not...
2026-03-27 (first published: 2026-03-06)
219 reads
The Book of Redgate: Mistakes
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
55 reads
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-23 (first published: 2026-03-06)
230 reads
Why I stopped using MCP for AI coding stuff
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not just posting about shipping—stopped talking about MCP. No dramatic announcement. No hot take thread. They...
2026-03-18 (first published: 2026-03-06)
1,079 reads
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we will discuss more on different free notebooks available to write / code LLM and get...
2026-03-05
46 reads
Where is my TNSPING?
I’m a big fan of the “instantclient” solution to Oracle connectivity. No more calls to “runInstaller”, no registry files on Windows, it is just download-unzip-go. That makes installation a...
2026-03-05
78 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