Lost Data
Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.
2010-07-01
152 reads
Editorials
On Being the 2009 Exceptional DBA
A guest editorial from Josef Richberg, winner of the Exceptional DBA contests in 2009.
2010-06-30
266 reads
The Breakfast Plan Goes Awry
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
2010-06-29
202 reads
Kudos to the Community
Steve Jones takes a day to thank everyone that donates their time to help others in the community.
2010-06-28
84 reads
The Great Forum Debate
Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.
2010-06-28
100 reads
The Phantom DBA
This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?
2010-06-25
317 reads
Dinosaur Databases
Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.
2010-06-24
421 reads
The Schema Debate
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
2010-06-22
644 reads
Making Your Career Go Further
Steve Jones comments on a few things that can help you, and are worth keeping in mind as you interact with people.
2010-06-21
252 reads
Moving to the Cloud
There has been a lot of talk about moving to cloud based computing, and cloud based services. Steve Jones comments on what this might mean today.
2010-06-21
316 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