Could you spare 3 minutes to help us out at SQL Server Central? Take this short survey, tell us about who you are and why you come to SQL Server Central, and you could win a $50 Amazon voucher.
A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping tips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to think about what we could do to […]
With the PASS Summit moving to a virtual format, Steve is going to support the event.
Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article.
From performance to recruitment, cloud adoption to estate growth, the findings from the 2020 State of Database Monitoring report offer us some key insights into the trends and challenges facing the industry this year. Redgate’s Jamie Wallis unpicks the findings in this latest blog.
An in depth look at the implications of using Banker's Rounding.
Today Grant talks about the challenges of sometimes finding good, current information.
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of heaps so that you can determine when heaps are the best choice.
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
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