Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...
2019-05-14
15 reads
I recently realized that I’m in the early stages of burnout. This isn’t an unfamiliar place for me, but it is new for me to recognize the early signs...
2019-05-14
11 reads
In order to vote you have to have filled out your profile on PASS.org. Rather than guess, take a minute to login and go to https://www.pass.org/MYPASS.aspx?viewctl=MyProfile. If you’re eligible...
2019-05-14
7 reads
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-14
14 reads
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-14
7 reads
This month we have a very interesting topic from Matthew McGiffen. He gets back to the roots of the party with code by asking a question on puzzles. It’s...
2019-05-14
37 reads
Speaking at SQLSaturday Atlanta!
I’m proud to announce that I will be speaking at SQL Saturday Atlanta on May 17th 2018! This one won’t let you down! Check out the amazing schedule!...
2019-05-14
4 reads
Speaking at SQLSaturday Atlanta! I’m proud to announce that I will be speaking at SQL Saturday Atlanta on May 17th 2018! This one won’t let you down! Check out the amazing schedule!...
2019-05-14
19 reads
Today it was a workshop day at SQLDay. Five workshops (one unfortunately has been cancelled). I think at least 300-350 people have attended the conference during the first day....
2019-05-14
27 reads
If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
673 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
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...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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