Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-01-23
30 reads
When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...
2024-01-22 (first published: 2024-01-04)
233 reads
Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
659 reads
altschmerz – n. a sense of weariness with the same old problems that you’ve always had, the same boring issues and anxieties you’ve been gnawing on for decades, which...
2024-01-19
24 reads
To build a custom Docker image we create a docker file with instructions in it. For example, a really simple custom SQL Server 2019 Docker image can be built...
2024-01-19 (first published: 2024-01-05)
298 reads
After a long hiatus of not blogging, I’m trying to get back into writing. So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...
2024-01-19
28 reads
SQL Prompt has an EAP using an AI model to help write code. I’ve been lightly experimenting with it, since I think AI is an interesting tech and it’s...
2024-01-19 (first published: 2024-01-05)
273 reads
When I was 11 I got my first computer, an 8088 with 4.5 mhz. I didn’t know much about computers at the time but I knew it was cool....
2024-01-17 (first published: 2024-01-04)
260 reads
There are plenty of times I’m called upon to fix data. To do this, I must know what dependencies are in the database. Foreign keys are a crucial aspect...
2024-01-17 (first published: 2024-01-02)
189 reads
We’re kicking off a major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The first course “Certified Kubernetes Administrator: Kubernetes Foundations” in the updated series is now available on...
2024-01-17
213 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
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...
When I run my query from DW, which uses a linked server, it times...
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
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