T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...
2018-11-13
227 reads
Blog Posts
T-SQL Tuesday #108 – Non SQL Server Technologies
It’s T-SQL Tuesday #108. This month’s topic is hosted by Malathi Mahadevan (B|T) and she asks us to… “pick one...
2018-11-13
229 reads
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one's career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change....
2018-11-13
3 reads
Why did my execution plan change?
As a SQL Server DBA it is important to understand why and how the SQL engine works. Understanding as much...
2018-11-13
2,856 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...
2018-11-12
14 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
355 reads
Notes From the 2018 PASS Summit (v20)
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
264 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...
2018-11-12
631 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
19 reads
Random Pix from the 2018 PASS Summit
A few memories from me. First, a beautiful late arrival view.
My first session feels a little lonely
It started to fill...
2018-11-12
784 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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