Master advanced DAX in Power BI and Microsoft Fabric to build scalable semantic models, solve complex business problems, and deliver high-impact analytics using real-world scenarios and proven techniques.
2026-08-05 (first published: 2026-06-22)
511 reads
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The SQL MCP Server is a part of the Data API Builder (DAB). DAB is a...
2026-08-05 (first published: 2026-07-27)
716 reads
This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().
2026-08-05
5,076 reads
Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.
2026-08-03
232 reads
2026-08-03
948 reads
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company you generally enjoy, like a poker player who keeps folding a promising hand in order...
2026-07-31
142 reads
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not your responsibility.” – from Excellent Advice for Living I’ve worked with a lot of people...
2026-07-31 (first published: 2026-07-24)
226 reads
2026-07-31
548 reads
Steve asks if we should focus on the slowest queries or tackle other issues in our systems. Or if we should even have to make these decisions.
2026-07-31
164 reads
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some sort of agent. I’m doing the same, but in this case, I had it tackle...
2026-07-29 (first published: 2026-07-22)
513 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...
WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...
Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
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