2010-09-03
106 reads
Editorials
Check Twice, Update Once
An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server.
2010-09-02
155 reads
Where Are the Programmers?
Today Steve Jones has a little fun with titles in technology, and what we might start to call ourselves instead of DBAs.
2010-09-01
253 reads
I Love the SQL Community
Steve Jones talks about the SQL Community and why it's so great. Hint: it's the people.
2010-08-30
181 reads
Project Phoenix
A great new project kicked off by MVP Arnie Rowland is available to people out there struggling with their careers, but looking to continue to grow them.
2010-08-30
235 reads
If You Had To Pick a Super Hero...
Today we have a guest editorial from Andy Warren that looks at a lighter topic that's fun for most geeks: super heroes.
2010-08-27
154 reads
Individual Contributions
Each person on a team, or even in a company, can contribute something. Steve Jones reminds us not to assume we are better than others because of our job.
2010-08-26
179 reads
The DBA Financial Analyst
Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.
2010-08-25
233 reads
When To Touch
When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.
2010-08-24
146 reads
DMVs: are they worth the effort?
Many of the SQL Server DMVs still have a wild, unfinished feel but they are an incredibly useful tool for DBA, well-worth the sweat and toil required to learn and query them effectively.
2010-08-23
452 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