Scaling Up Monitoring
How do we design a monitoring system? The Amazon Prime team realized they didn't do a good job and changed their architecture.
2023-05-31
180 reads
Editorials
2023-05-29
115 reads
Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
570 reads
AI Thoughts on the Build Keynote
Today Steve has a few thoughts, and links, from the Build Keynote last week, which featured AI technology.
2023-05-26
161 reads
The Best Graph
Today Steve discusses visualizations and how we would think about the information a client gets from them.
2023-05-24
194 reads
Database APIs
Today Steve talks APIs, which are important in much of software development. He thinks we ought to treat our database schema as part of an API.
2023-05-22
293 reads
Empathetic Design
An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge […]
2023-05-20
103 reads
2023-05-19
244 reads
2023-05-17 (first published: 2017-09-26)
271 reads
Finding Your Own Career
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
2023-05-15 (first published: 2019-12-11)
379 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