Quick Permissions Audit
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:
Easy Permissions Audit...
2019-01-14
28 reads
Jason Brimhall
Automatic Tuning Monitoring and Diagnostics
Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic...
2019-01-10 (first published: 2019-01-04)
2,709 reads
Automating like an Enterprise DBA
TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...
2019-01-08
671 reads
Automating like an Enterprise DBA
One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....
2019-01-08
19 reads
ArithAbort and SQL Agent Failures
ARITHABORT can be a short termed head scratcher. Pay close attention to what has changed in the environment. Test alternatives. And check those connection strings.
Related Posts:
Failed to Create the...
2019-01-07
17 reads
ArithAbort and SQL Agent Failures
ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...
2019-01-07
298 reads
Quick and Easy XE for Azure DB
The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....
2019-01-07 (first published: 2018-12-24)
1,499 reads
Short Circuiting Your Session
It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...
2019-01-05
23 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
34 reads
Event Tracing for Windows Target
There are many useful targets within SQL Server's Extended Events. Of all of the targets, the most daunting is probably the Event Tracing for Windows (ETW) target. The ETW...
2019-01-03
19 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