The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.
In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.
Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.
Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.
Summary This article aims at demystifying what grid search is and how we can use to obtain optimal values of our model parameters. It would be highly beneficial for the reader if the prequels to this article are read to gain a holistic understanding of the various techniques that can be used in optimizing the […]
There has been a trend to blame a single IT person, or a small group, for issues in large enterprises. Nowhere else in the corporate world would one person be blamed for a major failure.
DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.
Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.
This week there was an interesting article on DevOps and Ancestry.com's DevOps process. They are a fairly large enterprise, with 70+ teams that need to deploy code on a regular basis. As they've grown, there was some concern over each team learning how to best build their software pipeline. While they shared knowledge with each […]
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...
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...
Comments posted to this topic are about the item 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