SSRS Subscription Schedules – Enhanced
Reporting Services
Over the past couple of articles I have illustrated some of the fun that can be had when dealing...
2017-05-25
1,106 reads
Jason Brimhall
SSRS Subscription Schedules – Enhanced
With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to...
2017-05-25
322 reads
SSRS Subscription Schedules
With the ability to create content delivery schedules, or to subscribe to report content delivery, this imposes a requirement to also know when the various reports are scheduled to...
2017-05-23
37 reads
SSRS Custom Shared Schedule
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
Related Posts:
CRM Data Source Connection Error January...
2017-05-22
73 reads
T-SQL Tuesday #089: The Cloud and Job Security
Do you fear the coming turbulence of the Cloud uprising? I think the cloud is a good thing for the data professional, when done right.
Related Posts:
Coping with Self...
2017-04-12
9 reads
T-SQL Tuesday #089: The Cloud and Job Security
The Cloud
Today I am doing a quick entry for my participation points in the monthly blog party called TSQL Tuesday. I...
2017-04-12
606 reads
SQL Server Fixed Role Permissions
Roles and Permissions
Some of my recent articles have been focused on permissions and security. There is good reason for that – security...
2017-03-15 (first published: 2017-03-06)
3,106 reads
SQL Server Fixed Role Permissions
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...
2017-03-06
26 reads
SQL Server Permissions – Database Roles
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
92 reads
SQL Server Permissions – Database Roles
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,456 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