SQL Server configuration files
Problem: You require the ability to perform a repeatable standardised installation of multiple instances of SQL Server or the ability...
2014-02-13
45,560 reads
The Approachable DBA
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
504 reads
Without a Strong PaaS, ITaaS, DevOps & IaaS Fall Short #cloud
To lower IT operational costs and/or to become more agile, the business must simplify the processes to deliver and manage...
2014-02-13
250 reads
SQL Saturday Trip Report - Cleveland 2014
This past weekend I made the journey to Cleveland, OH (Westlake, actually) for SQL Saturday #241. I’ve attended two local SQL Saturdays in the past (helping organize/run one), but seeing...
2014-02-13
11 reads
MCSA in 90 days… & lot of resources
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts....
2014-02-12
1,483 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
14 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out...
2014-02-12
839 reads
Powershell in a Month Day 16 – Working with many objects
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-02-12
1,156 reads
On Why Titles Don’t Matter
The chief executive of eClinicalWorks says he guards against “title warfare” at his company, saying that new job titles “get...
2014-02-12
274 reads
Does Your Company Make You a Better Person?
Successful organizations place personal development front and center.
from HBR.org http://ift.tt/1aq03xy
via IFTTT
2014-02-12
391 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