As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as cloud adoption has matured, I’ve come to realise that building and running great systems isn’t...
2026-03-12
34 reads
Throughout my long history of working with the Oracle Database, there are some things that often just take for granted, on the assumption that they have always been present....
2026-03-12
28 reads
I hate writing these posts. On March 10, 2026, Microsoft dropped a security update that fixes CVE-2026-21262 – an Elevation of Privilege vulnerability in SQL Server. If you’ve got...
2026-03-11
47 reads
In the realm of software development and content creation, the deployment pipeline serves as a crucial bridge between innovation and implementation. Whether you are fine-tuning code, testing new features,...
2026-03-11 (first published: 2026-03-03)
396 reads
Quite the title, so let me set the stage first. You have an Azure Data Factory instance (or Azure Synapse Pipelines) and you have a couple of linked services...
2026-03-11 (first published: 2026-03-03)
441 reads
Continuing from Day 9 where we covered HuggingFace — today on Day 10 we would talk about LangChain and LlamaIndex. these are two very popular frameworks that make building...
2026-03-10
16 reads
This T-SQL Tuesday is hosted by the one and only James Serra – literally my go-to guy for data lakes and BI architecture. I am so tickled to be...
2026-03-10
44 reads
This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...
2026-03-10
22 reads
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)
31 reads
today on Day 9 I would like to talk about HuggingFace. if you are learning AI practically, HuggingFace is one of the most important platforms you will come across....
2026-03-09
24 reads
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers