I’m thrilled to announce a three-part remote education event in conjunction with the Iowa SQL Server community! The topic is SQL Server IaaS and virtualization performance tuning, and it’s...
2021-12-31 (first published: 2021-12-12)
272 reads
Back in March 2020 Glenn Berry created the #SQLFamily Folding@Home team and many of us joined in donating compute cycles to helping find a cure for various diseases to...
2021-12-22 (first published: 2021-12-12)
244 reads
Last Updated on January 9, 2022 by John Morehouse Recently I was looking to install VMWare components in my local network of things so that I could gain additional...
2021-12-10
21 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ll do a post on how to easily...
2021-12-10
34 reads
This blog post shows you how NTFS stores data, what the NTFS Allocation Unit means, and how SQL Server performs IOs of variable size.
How NTFS Stores Data on Disk...
2021-12-29 (first published: 2021-12-10)
507 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-10
25 reads
Microsoft recently came out with a blog on a bunch of new features available for Azure Synapse Analytics (see Azure Synapse Analytics November 2021 Update), and I wanted to...
2021-12-20 (first published: 2021-12-09)
210 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-09
30 reads
Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute...
2021-12-09
144 reads
Want to learn and use Google Cloud Storage?
What is Cloud Storage & Bucket?
Type of Disk avilable in Cloud Storage?
Lets Start! Continue reading ?
2021-12-09
40 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