One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up...
2020-04-17 (first published: 2020-04-08)
404 reads
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing threat of COVID-19. As much as we wanted to put this event on, the safety...
2020-04-03
13 reads
I’ve been working remotely for just over 2 years now and my current position is my first remote post. Before joining my current company I (and them) had concerns...
2020-03-11
26 reads
When working with multiple Kubernetes clusters, at some point you’ll want to merge your kubectl config files. I’ve seen a few blogs on how to merge kubectl config files...
2020-02-21
318 reads
Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering!...
2021-05-03 (first published: 2020-01-29)
323 reads
2019 was a busy year for me. I presented sessions in over 10 countries, averaging speaking at two conferences per month. I also helped organise Data Relay and attended...
2020-01-23
10 reads
At Data Céilí 2020 we want to be as green as possible and one idea we’ve had is to run a Green Track that will host remote sessions from...
2020-01-08
16 reads
I’ve seen a few people online asking how to use docker named volumes with the new SQL Server 2019 RTM images. Microsoft changed the way SQL runs within a...
2019-11-25 (first published: 2019-11-18)
3,717 reads
The GitHub Package Registry is available for beta testing and allows us to store container images in it, basically giving us the same functionality as the Docker Hub. However...
2019-10-23
61 reads
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
1,002 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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