Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?
We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16...
Arshad Ali demonstrates how to verify the SQL Server Service Broker (SSBS) configuration when both the Initiator and Target are in different SQL Server instances, how to communicate between them and how to monitor the conversation.
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Title pretty much says it all - can this be done? I've tried several...
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
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