Dynamic Data Masking
Dynamic Data Masking
FEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...
2015-02-26
14 reads
Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2015-03-11 (first published: 2015-02-26)
8,913 reads
Parsing SQL Saturday Data – Getting Titles from the XML document
I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database....
2015-02-25
1,443 reads
Using sp_DBPermissions and sp_SrvPermissions v6.0
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....
2015-02-25
1,298 reads
Solving a slow running query issue with UNION
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...
2015-03-09 (first published: 2015-02-25)
8,830 reads
PWDCOMPARE–a hidden function of SQL SERVER TIP #88
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to...
2015-02-25
952 reads
How to Encrypt password in SQL Server ? TIP #87
Security is always a concern for every database developer. How to secure valuable information is one of the major and...
2015-02-24
433 reads
Presentation slides for “Building a Big Data Solution”
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...
2015-02-24
983 reads
Check Out Josh’s Blog on Creating Percentile in DAX
I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering...
2015-02-24
754 reads
T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases
There are many different ways to accomplish this tasks.
Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6
The below examples uses undocumented sp’s to loop through all the...
2015-03-06 (first published: 2015-02-24)
7,001 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
Alamat BCA KCP Batu Ceper Telp:08218200203
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Kartini Telp:08218200233
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Alamat Bank BCA Wisma 46 Telp:08217555651
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
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