T-SQL Tuesday #47: My Best SQL Server SWAG
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-10-08
1,218 reads
Kendal Van Dyke
T-SQL Tuesday #47: Your Best SQL Server SWAG
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,666 reads
A Tainted PASS Elections
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to...
2013-10-02
845 reads
Practical PowerShell: Merge SQLSaturday Speaker SpeedPASSes Into One PDF
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...
2013-09-19
1,401 reads
24 Hours Of PASS: 2013 Summit Preview Starts In Less Than 24 Hours!
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,344 reads
Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break
We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...
2013-04-24 (first published: 2013-04-11)
3,807 reads
SQL Power Doc Update - Version 1.0.1.0
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,020 reads
T-SQL Tuesday #41 - Presenting Opens Doors
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
958 reads
T-SQL Tuesday #39 - Use PowerShell To Copy A Database To Another Instance
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,031 reads
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,756 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 Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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