The Code Freeze
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
2024-04-10
227 reads
Editorials
2024-04-08 (first published: 2019-08-21)
945 reads
To Each Their Own
I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. […]
2024-04-06
101 reads
When is it time for a new job?
Steve asks the question today about when you might think about changing employers. He has some advice for you, whether you're happy or in need of a new position.
2024-04-05
206 reads
Under the Bus
Today Steve discusses a disturbing trend, where technical workers are being thrown under the bus by management.
2024-04-03
244 reads
CosmosDB APIs Inside SQL Server 2024
New enhancements in SQL Server 2024 will allow MongoDB and Cassandra clients to store their data in a SQL Server database, in native NoSQL format.
2024-04-01
209 reads
Database Mirroring is Back in Azure SQL Database
Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.
2024-03-30
485 reads
The Journey to Change
Many of us have a journey, either to SQL Server, or in today's world of many databases, perhaps away from SQL Server. Steve looks at his, and another's, journies.
2024-03-29
135 reads
The Cloud Database Cost Analysis
Managing costs in the cloud is something many companies are concerned about. Today Steve thinks that technical people will bear more responsibility for this in the future.
2024-03-27
281 reads
Another View of DevOps
Steve does a lot of work with teams trying to adopt DevOps, and today has another description of what this can mean for your team.
2024-03-25
210 reads
Blogs
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...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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