Earlier this week, I recorded a talk called “AI: The Good, Bad, and the Future.” I talked about some of the good things that have happened with AI and some of the Bad. But what I really wanted to focus on was the future. I think many of us have heard the two letters AI […]
2026-09-12
141 reads
Last week, I had the chance to speak at two very different events, and the contrast between them really stuck with me. The first was all a traditional vendor conference- enterprise-level, built around a well-established product with over 40 years of vendor-driven development. Think polished sponsor tables, polished shoes, and more than a few suits […]
2025-04-12
97 reads
Learn how you can use AutomatedLab to quickly create new environments.
2023-08-04
2,920 reads
This article delves into five new dbatools command that work with sequence objects.
2023-05-31
1,582 reads
Background The dbatools module is broadly used and is an ever-growing set of useful commands. While looking for some inspiration I checked the old issues logged on the GitHub repository. Finally, I found this one Remove-DbaDbMail Profile and Account · Issue #4990 · sqlcollaborative/dbatools (github.com). The issue was more than 2.5 years old (32 months). […]
2021-11-01
3,765 reads
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
Join the world’s largest gathering of data professionals at this year’s free online PASS Data Community SUMMIT. Connect and network with 1000s of your peers and learn from some of the brightest minds in the data industry. This year’s must-attend online event is completely free, so sign up now to be notified when registration opens.
2021-05-28
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers