Fitting Into RAM
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
288 reads
Editorials
The Changing Landscape of Community
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
146 reads
Keep Sharing
I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]
2023-07-01
83 reads
Planning for a Bad Day
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
2023-06-30
158 reads
Securing All Your Connections
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
2023-06-28
219 reads
Concurrency Challenges Around Schema Changes
A post on distributed systems and how schema changes are handled caught Steve's eye. See if you agree with how he thinks this should work.
2023-06-26
146 reads
2023-06-24
175 reads
The Reliable DBA
One of the important qualities for a database is being reliable. However, as your organization grows, you might need to ensure that your account for your people as well.
2023-06-23 (first published: 2018-03-13)
255 reads
Who's Responsible?
If mistakes are made, employees can be held financially responsible by some companies. Do we need to worry about this in our industry?
2023-06-21 (first published: 2017-08-29)
212 reads
Highly Skilled
The highly skilled people are changing and getting jobs. A recent report notes this is of concern to executives and hiring practices may be changing. Steve has a few hints for how you can grow your own career and find new opportunities.
2023-06-19
239 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...
Is it worth hiring experts for BI implementation?
When your team is spending more time gathering data manually or generating reports in...
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...
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