Why Databases Still Fascinate Me
I get asked a lot about why or how I began working with databases years ago. I did not wake up one day and decide, “I am going to...
2025-11-28 (first published: 2025-11-10)
420 reads
The SQL Professor
Query Intelligence in SQL Server 2025: What Developers Need to Know
When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental...
2025-11-26 (first published: 2025-11-05)
715 reads
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
When it comes to managing complex database environments, having the right monitoring solution is critical. That’s why I’ve relied on Redgate Monitor at different points in my career. It...
2025-11-17 (first published: 2025-11-02)
269 reads
Measuring What Matters: Operationalizing Data Trust for CDOs
Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies collapse under the weight of doubt. For Chief Data...
2025-10-30
16 reads
Designing for Observability in Fabric Powered Data Ecosystems
In today’s data-driven world, observability is not an optional add-on but a foundational principle. As organizations adopt Microsoft Fabric to unify analytics, the ability to see into the inner...
2025-10-27
35 reads
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
Change is inevitable. What separates thriving organizations from those that falter is not the scale of disruption but how leaders respond to it. In times of shifting technologies, evolving...
2025-11-12 (first published: 2025-10-20)
335 reads
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
For decades, enterprises have thought about data like plumbers think about water: you build pipelines, connect sources to sinks, and hope the pipes do not burst under pressure. That...
2025-11-05 (first published: 2025-10-17)
448 reads
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
There was a time when the Chief Data Officer lived in the shadows of the enterprise. Their office lights burned late into the night as they combed through spreadsheets...
2025-10-14
16 reads
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The attic was called the data warehouse, and while it...
2025-10-29 (first published: 2025-10-09)
319 reads
From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset
There are moments in technology when the ground shifts beneath our feet. Moments when the tools we once thought of as reliable utilities suddenly become engines of transformation. SQL...
2025-10-06
161 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
BIT_COUNT I
Comments posted to this topic are about the item BIT_COUNT I
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers