Malathi Mahadevan (blog|twitter) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community.
Malathi has asked us to:
Pick one thing you want to learn that...
2018-11-06
15 reads
As DBA’s we are sometimes put in a rock and hard place when it comes to database performance. This situation...
2018-11-06 (first published: 2018-10-29)
4,539 reads
Come see my inaugural presentation at the Lexington PASS User Group meeting, Tuesday, Nov 13th, at 6:30 PM at the Blue Stallion Brewing Co. Azure Data Studio [pptx 6MB]
2018-11-06
36 reads
I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...
2018-11-05 (first published: 2018-10-23)
2,235 reads
Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....
2018-11-05
637 reads
One of the common goto methods for query specific slowness which can be replicated via an application can be to...
2018-11-05 (first published: 2018-10-24)
2,216 reads
Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...
2018-11-05
192 reads
Honestly, that’s a very hard question to answer. I mean, first of all, you can look at the schedule. There...
2018-11-05
205 reads
Good morning folks! I wish you very good week at work, at home or wherever you are/will be. Last week...
2018-11-04
65 reads
On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...
2018-11-04
12 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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