SQL Server Tracking Tempdb Size
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
498 reads
All About SQL
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
367 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,712 reads
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,592 reads
Azure SQL Database Active Geo Replication Changes
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
530 reads
SQL Server Tracking Suspect Pages
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,606 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
676 reads
Azure SQL Database Resumable Online Index Rebuild
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,366 reads
DBCC CHECKDB Azure SQL Database
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
757 reads
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,240 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 Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT 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