Predictions for the Future
Steve Jones looks forward with a few predictions for how the world might change for SQL Server professionals.
2018-03-06
91 reads
Editorials
Decouple the Tools
The decoupling of some tools from SQL Server seems to be working. Perhaps Microsoft should decouple them all.
2018-03-05
91 reads
2018-03-05
60 reads
2018-03-02 (first published: 2014-07-24)
202 reads
Elevation of Privileges
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?
2018-03-01 (first published: 2014-07-30)
287 reads
Monitoring for Non Existent Events
Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.
2018-02-28 (first published: 2014-07-31)
210 reads
2018-02-26
53 reads
What Counts for a DBA – Inspirations
In order to be great, you need to have an idea what great is. A quote I use in every one of my database design presentations is by one of my non-technical inspirations, C. S. Lewis. The quote is from his book, An Experiment in Criticism. “There are no variations except for those who know […]
2018-02-26
51 reads
Build a Career Radar
A technology radar can help you assess what's important and where to focus your effort. Companies use these, and Steve Jones says you should as well.
2018-02-23
94 reads
An AI Loophole
We can't always explain how AI systems work. Steve Jones wonders if this is a loophole in the GDPR legislation.
2018-02-22
156 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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