SQL Server is undoubtedly a popular way to manage database. Due to its efficiency, business organizations largely depend on this for data management. This dependency often causes performance bottlenecks...
2018-11-17
44 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
23 reads
Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...
2018-11-17
31 reads
There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is...
2018-11-16 (first published: 2018-11-02)
1,896 reads
“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch...
2018-11-16
201 reads
AdvertisementsSQL server error log load to a table
There are cases, we need a SQL server error log load to a table...
2018-11-16
375 reads
As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage...
2018-11-16 (first published: 2018-11-06)
2,546 reads
Be sure to subscript to our RSS feed to keep up with the latest SQL Server news and tips!
http://vitamindba.com/feed/
The post...
2018-11-16
305 reads
This post is a response to this month’s T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way...
2018-11-15 (first published: 2018-11-06)
2,669 reads
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
263 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...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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