Nope to NoOps, No way to NoDBA
Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.
2015-08-17
272 reads
Editorials
How many environments?
This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.
2015-08-14
159 reads
Deploy from VCS
Are you brave enough to redeploy your applications from a VCS? Have you really captured all your code?
2015-08-10
95 reads
2015-08-10
127 reads
Teambuilding
This week Steve Jones wants to know about your efforts to create bonds with co-workers and build a team. Does your company do anything to help facilitate this?
2015-08-07
123 reads
2015-08-06
259 reads
Cloud Security Issues
The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.
2015-08-04
150 reads
2015-08-03
250 reads
But we've always done it that way…
Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.
2015-08-03
161 reads
How To Keep Up with SQL Server
It can be a challenge to keep up with the rapidly evolving SQL Server platform. Andy Warren has a few ideas today.
2015-07-31
384 reads
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
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