Prevent Confidential Data at the Application Layer from getting into SQL Server
In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.
2014-09-22
8,091 reads
Security
A few reflections on security by a weary application developer
Data security? No worries! Tell me how much you are willing to pay.
2014-09-03
190 reads
Change password for user 'sa'
Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.
2014-08-20 (first published: 2014-08-13)
1,923 reads
Data Driven Security
Set a security standard across environments that developers can see and run, but not change.
2014-07-30
3,899 reads
New SQL Server 2014 Permissions: CONNECT ANY DATABASE
CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?
2014-07-29
15,267 reads
2014-07-02
2,123 reads
2014-06-19
1,588 reads
Cloud Storage Security: Are You Doing Your Part?
If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?
2014-06-18
125 reads
2014-06-16
1,913 reads
2014-06-03
1,977 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