Enhancing Client Experiences with Data and Analysis
Data can enhance the experience our client's have with software.
2021-09-03
115 reads
Editorials
Where We Need Better AI Disclosure and Responsibility
The way that AI is used in the world can make it better, but not always. In either case, we ought to have some accountability for the models.
2021-09-01
218 reads
Eyes Wide Open
Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.
2021-08-30
182 reads
What to do with more free time
Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]
2021-08-28
263 reads
Are You a Tech Company?
Is your company a tech company? Steve Jones looks at the world from the perspective of software development and how that impacts business.
2021-08-27 (first published: 2016-09-20)
142 reads
Does Log Data Belong in a Table or a File?
Today we have a guest editorial that asks how one might want to manage all those logging metrics produced by applications.
2021-08-25 (first published: 2016-09-06)
316 reads
2021-08-23 (first published: 2018-04-23)
413 reads
2021-08-21
396 reads
A New Community Summit
The PASS Data Community Summit is coming back this November, and it's free to attend.
2021-08-20
166 reads
Better SQL is a Good Career Investment
Today Steve notes that learning to be better at SQL is a good career investment, more for you than your boss.
2021-08-18
438 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