PASS Summit Cosmos DB Demo Code
As part of the PASS Summit conference session that Bob Pusateri and I are presenting right now called “Cosmos DB...
2018-11-09
186 reads
Blog Posts
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other...
2018-11-09
29 reads
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be...
2018-11-09
2,312 reads
Vote for the PASS Board of Directors
Voting is open for the PASS Board of Directors. It’s a non-event this year, with three open positions and three...
2018-11-09
862 reads
Creating a Quick Dashboard Widget
I read Carlos Robles blog on creating an Azure Data Studio (ADS) insight widget and decided to try this for...
2018-11-08
1,036 reads
Enable Machine Learning Services on SQL Server
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform data analysis from the database itself using T-SQL.You can...
2018-11-08
10 reads
Enable Machine Learning Services on SQL Server
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform...
2018-11-08
2,945 reads
Live blog: Women in Technology lunch at #PASSSummit #passwit
11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering...
2018-11-08
207 reads
PASS Summit 2018 – Day 2 – 11/8/2018
It is day 2 of the summit already, am at the bloggers table again, waiting for the rest of the...
2018-11-08
161 reads
PASS Summit 2018 – Keynote Day 2 Commentary
It’s the second main-session day of the Summit for the Professional Association of SQL Server. I had a great breakfast this morning with Brent Ozar, along with Nathan and...
2018-11-08
6 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