Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2019-01-03 (first published: 2018-06-12)
8,753 reads
There are many useful targets within SQL Server’s Extended Events. Of all of the targets, the most daunting is probably...
2019-01-03
1,353 reads
There are many useful targets within SQL Server's Extended Events. Of all of the targets, the most daunting is probably the Event Tracing for Windows (ETW) target. The ETW...
2019-01-03
15 reads
Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...
2019-01-03 (first published: 2018-12-21)
2,881 reads
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,447 reads
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,563 reads
If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an...
2019-01-03
1,613 reads
In late December 2018 I had a discussion with Amanda Martin the PASS Community Manager around things that I would...
2019-01-03
208 reads
I’m delighted to announce I’m selected to speak at the 2019 edition of SQLGrillen DataGrillen. This is a German conference with the catchy tagline “Data, beer und Bratwurst”. I...
2019-01-03
17 reads
I recently spoke at the GroupBy free online conference. It was loads of fun, and the recordings from the event are now available. Here’s the hour long session I...
2019-01-03
9 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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