Speaking at GroupBy Conference – Spring 2020
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...
2020-05-06
17 reads
Blog Posts
SQL Server Architecture – Network Protocols, Database, Storage & Relation Engine, SQLOS
SQL Server Architecture SQL Server is Microsoft RDMS that works on a client-server architecture. Here, End-user sends a request and SQL Server accepts, process, and share the result with...
2020-05-06
583 reads
TIL: Get-DbaLastBackup
(This post comes from one of our Junior DBAs – @SQLDork) I’ve been learning dbatools over the past week or so, you can read the previous blog posts here...
2020-05-06
27 reads
Tracking Costs in Microsoft Azure via Tags
Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”. What is the best...
2020-05-06
109 reads
Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-05-06 (first published: 2020-04-24)
607 reads
Daily Coping 5 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-05
26 reads
SQL Prompt Fixes Always Have an Else
SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-05-05 (first published: 2020-04-22)
284 reads
Stacking Up Datasets in Azure Data Factory
(2020-Apr-24) Using UNION SQL operator is a very common practice to combine two or more datasets together, it helps to create a single result set from many sourcing ones. Azure Data...
2020-05-05 (first published: 2020-04-24)
423 reads
Daily Coping 4 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-04
43 reads
Database Fundamentals #24: More Filtering Data
In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE...
2020-05-04
117 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