Watch out for your own confirmation bias
First, a true story: I was a senior in high school, applying for college. One of the colleges I applied for was the Naval Academy. As part of the...
2020-06-08 (first published: 2020-05-22)
355 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
New Webinar with Kevin Kline: Learning from Data Breaches, a Deeper Dive
I’ve done a follow-on to my webinar with Kevin Kline on Learning from Data Breaches. Here we’ll talk about some specific technologies that come out of the box with...
2020-05-12
33 reads
New Article: Understanding SQL Server Ownership Chaining
Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...
2020-04-21
50 reads
Upcoming Webinar: Learning from Data Breaches
Recently I partnered up with Kevin Kline (SentryOne blog | twitter) and SentryOne to record a webinar on learning from data breaches. We start by talking about Mitre’s ATT&CK...
2020-04-13
32 reads
Cross-Post: Learning From Technology’s Past
Cross-posted from the ISACA Now Blog: “This is the song that doesn’t end. Yes it goes on and on, my friends.” – Lewis, S., “The Song That Never Ends,” Lamb-chop’s...
2020-03-20 (first published: 2020-03-11)
217 reads
Webinar Postponement and #SQLPASS group leaders heads up
Yesterday I wrote about three upcoming webinars I’m giving, which you don’t need to be in attendance for. Unfortunately, the one scheduled for next week with Idera and BankDirector...
2020-03-13
25 reads
SQL Server Security and Performance Webinars – March 17 – April 8, 2020 #FlattenTheCurve
In response to the Coronavirus (COVID-19) epidemic, we’re seeing folks react smartly by cancelling or rescheduling events where a large number of folks gather together. We have even seen...
2020-03-12
36 reads
Let’s Call It What It Is: Complexity Debt
Technical debt get deprioritized too often because business sees the word, “technical.” It doesn’t matter what the true meaning is. And it’s a big problem. It really needs proper...
2020-03-09 (first published: 2020-03-02)
601 reads
Midlands PASS: SQL Server Security Basics
Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly user meeting. We’ve been on hiatus since the holidays but we should be meeting regularly...
2020-02-27
47 reads
Renewed as a Friend of Red Gate
I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare...
2020-02-25
21 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
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