Webinars

Technical Article

Webinar: What Application Owners Need to Know About SQL Server

  • Article

If you own a business application, you’re accountable for its uptime, its cost, and its performance, even if you’ve never opened SQL Server Management Studio in your life. But most guidance out there is written for DBAs, not for the people who actually make decisions about the app.
This webinar on Sept 16 is different. We’ll walk through real findings from real SQL Server environments — the kind of things that quietly cause slow page loads, failed backups, and surprise outages — and translate each one into what it actually means for you: What did it cost? What was the risk? What would you have needed to ask your team (or your vendor) to catch it sooner?

You rated this post out of 5. Change rating

2026-09-09

Technical Article

Webinar: Compliance Without Compromise: Test Data Management That Finally Fits

  • Article

You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.

You rated this post out of 5. Change rating

2026-03-18 (first published: )

Technical Article

Webinar: The Impact of the Cloud on Databases

  • Article

The PASS Data Community Summit is back in Seattle this November, with hundreds of speakers covering a wide variety of database topics, including cloud computing. We feature two of those speakers in this webinar: Bob Ward of Microsoft and Steve Jones of Redgate.

You rated this post out of 5. Change rating

2023-09-15 (first published: )

Blogs

Using the Data API Builder–VS Live San Diego Resources

By

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

Running a Local LLM On Your Laptop Resources

By

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

Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger

By

I was creating a question on sp_readerrorlog and realized that this procedure is different...

Read the latest Blogs

Forums

Implementing Type 4 Slowly Changing Dimensions in SQL Server

By Dinesh Asanka

Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...

The Disabled Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Disabled Index

Server-Level Table sizes

By Artur Sanin

Comments posted to this topic are about the item Server-Level Table sizes

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