Stealth Updates
Editorial coming next week, but so far this is amazing to me. Microsoft's stealth updates of their client update tool....
2007-09-14
618 reads
The Challenges of Podcasting
OK, here's one take. Not sure if it's any good, but it's a start.
No live editorials yet. I've been working...
2007-09-13
665 reads
Podcasting
I'm working on getting a small studio set up for some podcasting of the editorials. That means I put a...
2007-09-12
2,237 reads
How Many Good Hours Do Employees Work?
You might call me a bean counter, but it's a fact that every manager needs to manage the distractions that...
2007-09-11
526 reads
Dell Selling an iSCSI Box
Saw an plug for it from our sales rep yesterday, MD3000i. Starts at $7300 with just a couple drives, goes...
2007-09-11
500 reads
Vacation... and the need for it
I have been on vacation the last week, which meant I spent the previous three weeks at work preparing to...
2007-09-10
614 reads
SQLSaturday - Who are the Customers?
For those who might not have browsed previous posts I'm heading up a free one day training event called SQLSaturday...
2007-09-10
549 reads
SQL 2008 CTP4 Available - If you have time!
Makes me yearn for a faster connection, about a 2300 mb download to get all the various pieces and if...
2007-09-10
1,260 reads
Background Images in Reporting Services posted on SSC
I wrote this up based on some questions in our recent BI class where we spend almost a full day...
2007-09-06
535 reads
CodePlex, CodeZone, and Connect
You might have visited these already, but it's interesting to see MS diversify a bit from the standard MSDN template....
2007-09-06
969 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
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