The Mysterious Empty Table
It seems like no matter how long you work with a system beyond a trivial size, you’ll find something new every so often. A little while ago, I found...
2025-02-26 (first published: 2025-02-17)
390 reads
When is the perfect moment to build a data strategy in a company?
Introduction The challenge enterprises face is adopting new technologies to manage data. But, even more importantly, using the latest technologies is not a solution by itself, and companies should think first about adding value to the organization through...
2025-02-16
11 reads
Choosing to not drive the Tesla
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla at home recently. A few people asked me about it, so I decided to do...
2025-02-14
40 reads
Advice I Like: Transactions and Relationships
Life gets better as you replace transactions with relationships. – from Excellent Advice for Living This is incredible advice. I think that much of the complaints about the US...
2025-02-14
20 reads
The pros and cons of self-service BI: What every industry leader should know
Introduction Growing enterprises or businesses that want to remain competitive must make quick decisions daily. While experience and expertise are essential in that process, making those critical calls is...
2025-02-14
11 reads
Free PostgreSQL Performance Monitoring with pgNow
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute Beginner.” There are several ways to get an understanding of how well your queries are...
2025-02-21 (first published: 2025-02-13)
338 reads
Top 10 Careers in Data
Would you re-order these? Machine Learning Engineer $$$$$ Develop and deploy AI models Optimize machine learning algorithms for efficiency Work with big data frameworks to process large datasets Data...
2025-02-28 (first published: 2025-02-13)
334 reads
Building Effective Data Governance Framework: Top Areas to Focus On
Introduction Building a practical data governance framework can feel like building a house: you need a strong foundation, reliable materials, and the right team to make it all work. Data governance is crucial for organizations to manage, protect, and utilize their data effectively. A well-defined framework...
2025-02-13
17 reads
Dealing with Changing Data Formats: Schema Drift in Azure Data Factory
(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in a sense, already feels like an opening statement.Moving data between two or more endpoints is...
2025-02-24 (first published: 2025-02-12)
465 reads
Adding Manual Relationships Between Tables in the TDM Subsetter
I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things...
2025-02-24 (first published: 2025-02-12)
128 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
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