What’s new with Power BI?
At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were...
2021-05-26 (first published: 2021-05-17)
877 reads
Tech Field Day 23 Recap
April 21 to 23 saw a new milestone for me. I was a new delegate for the 23rd Tech Field Day! It’s an absolute honor and thrill to be...
2021-05-17
28 reads
Daily Coping 17 May 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-17
17 reads
Running a SQL Server container from scratch
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
650 reads
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I’ve started to realise that...
2021-05-21 (first published: 2021-05-17)
447 reads
Career: Talk To References
As we try to get through these strange times in the world, I am starting to see a bit more career movement in 2021 than I saw for much...
2021-05-21 (first published: 2021-05-14)
179 reads
This Saturday: #DataWeekender, DataSaturday Southwest
Geeked to be speaking 2x on Saturday May 14, my second time speaking at #DataWeekender and at the very first Data Saturday Southwest 2021.
My Certification Exams Inside Out is one...
2021-05-14
12 reads
Daily Coping 14 May 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-14
12 reads
A Very Simple Blocking Alert
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-13
12 reads
A Very Simple Blocking Alert
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-24 (first published: 2021-05-13)
726 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 BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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