2021-12-17
279 reads
Editorials
2021-12-15
356 reads
Acknowledging Success
Annual awards are a fun thing for Steve, and he hopes more organizations will start doing them.
2021-12-13
227 reads
One to many SQL Server books
Back in the late 90s, I had one large book on my desk with everything I needed – or thought I needed -- to know about SQL Server. It covered T-SQL, installation, backups, security, and more. Over the years, Microsoft has added components like SQL Server Integration Services and features like windowing functions and improved […]
2021-12-11
384 reads
2021-12-10 (first published: 2017-03-30)
257 reads
Worse Before Better
We need to approach software development with a balance of making things better, and ensuring they work.
2021-12-08
225 reads
2021-12-06
330 reads
Holiday Fun for Your Career
The Advent of Code is live, and Steve finds it to be a fun way to take a break during your day.
2021-12-04
295 reads
When to Use a Database
While relational developers and administrators might always want to use a database, that might not be the case for those that analyze data. Steve suggests you help them see the value of a database platform.
2021-12-03
498 reads
Building a Production Database
Lessons learned from building a database caught Steve's eye, and he has a few comments.
2021-12-01
619 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
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