Your Data After Life
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
369 reads
Editorials
Carefully Giving Normal Users Security Permissions
When we need to delegate work to less privileged users, Steve has an idea.
2020-07-16
198 reads
2020-07-15
179 reads
2020-07-14
122 reads
Beating the Cloud Vendors
Can you run a system better than cloud vendors? You should know and be able to prove it.
2020-07-13
140 reads
Controlling Intelligent Query Processing Features
I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
2020-07-11
821 reads
Moving away from an RDBMS
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
707 reads
2020-07-09
106 reads
Better Laptop Life
Intel is building hybrid processors, combining the power of the regular CPUs most of us use with Atom power saving technology.
2020-07-08
125 reads
2020-07-07
747 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...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
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