Static Data Masking (SSMS 18.0 Preview)
Ever need to have a test database on hand that you can allow others to query “real like” data without...
2019-01-02 (first published: 2018-12-19)
2,703 reads
Blog Posts
Versions and Patches in SQL Monitor
SQL Monitor has grown from a basic alerting system to an amazing product over the years. From it’s early days...
2019-01-02
291 reads
Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).
Watch...
2019-01-02
17 reads
Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).
Watch...
2019-01-02
4 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
4 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
6 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as...
2019-01-01
1,000 reads
An error occurred while writing an audit trace. SQL Server is shutting down
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
29 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
24 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
425 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers