Azure Database for PostgreSQL
Having worked with Azure SQL Database and its many flavours for couple of years now I am confident in building deploying, whether manual or templates. Being in Azure you...
2020-02-18
34 reads
All About SQL
Azure SQL Database and Error Handling
For some reason I have friends / colleagues telling me that when scaling (up and down for this example) that no downtime occurs. Well, not only does Microsoft documentation...
2020-02-11
280 reads
Azure Advisor – for Azure Data Platform
Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management...
2020-02-03
24 reads
Amazon Web Services (AWS) vs Azure Features List
After much reading through the internet looking for Amazon’s equivalent of Microsoft’s Azure functions (Lambda), I found this outstanding link that ” helps you understand how Microsoft Azure services...
2020-01-13
232 reads
Common Things Admins Miss in Azure SQL DB
This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure...
2020-01-08
56 reads
Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs
This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...
2020-01-06
43 reads
SQL Server Christmas Script
Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...
2019-12-19
57 reads
Azure SQL Database – Automatic Tuning – Have you enabled it?
Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so: CREATE INDEX DROP INDEX FORCE LAST...
2019-12-09
69 reads
SQL Server 2019 eBook
SQL Server 2019 is ready available for use, but before you download you should review the webinars, white papers and eBook available on the technology (definitely the eBook ??...
2019-12-02
272 reads
Execution Plans in Azure SQL Database
Yes you can still get execution plans for Azure SQL Database, you cannot get this from the Azure Portal so it is good to know for your tuning days....
2019-11-20
110 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