Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

Bad Admins: Stealing An Account

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...

2011-07-14

1,198 reads

Bad Admins: Attacking via Group Membership

by Brian Kelley

Databases – Infrastructure – Security

This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...

2011-07-13

1,878 reads

Gaining Speaker Experience Credentials

by Brian Kelley

Databases – Infrastructure – Security

One of the things I saw on Twitter yesterday was several folks saying their abstract submissions had been turned down...

2011-06-16

1,902 reads

Speaking at the 2011 PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...

2011-06-15

894 reads

Planning Your Upgrade Well

by Brian Kelley

Databases – Infrastructure – Security

Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...

2011-06-07

970 reads

The Importance of a Business Recovery Plan

by Brian Kelley

Databases – Infrastructure – Security

Recently I was in one of those chain restaurants (the middle-priced, sit-down types) and shortly after we got there, we...

2011-06-06

1,902 reads

Re-Focusing the Blog a Bit

by Brian Kelley

Databases – Infrastructure – Security

In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...

2011-06-01

751 reads

Project Management: Dedicated vs. Shared Resources

by Brian Kelley

Databases – Infrastructure – Security

As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...

2011-05-13

18,925 reads

You Are Responsible for You

by Brian Kelley

Databases – Infrastructure – Security

Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...

2011-05-12

748 reads

Dealing with Frustration in the Workplace

by Brian Kelley

Databases – Infrastructure – Security

Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...

2011-05-11

3,036 reads

Blogs

What Does It Mean to Make Data AI-Ready?

Making Data AI-Ready, Part 1 (This is the first article in a three-part series...

Using the Data API Builder–VS Live San Diego Resources

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

Running a Local LLM On Your Laptop Resources

Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...

Read the latest Blogs

Forums

Alamat BCA KCP Summitmas Telp/Wa:0821-8200-203

By layanan_Bca88

Hub Cs 08218200203 Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, RT.5/RW.3,...

Alamat BCA KCP Iskandar Muda II Telp:0821-8200-233

Telp/Wa 62 8218200233 Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama Sel., Kec....

Alamat BCA KCP Bona Indah Telp/Wa:0821-8200-233

Hub Cs 08218200233 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb....

Visit the forum

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