The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
156 reads
Editorials
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
2022-03-14
131 reads
2022-03-11 (first published: 2017-05-04)
315 reads
The (Former) Complexity of PowerShell
Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.
2022-03-09 (first published: 2017-01-19)
427 reads
Would You Still Love Linux If Windows Was Free?
A guest editorial today looks at the OS debate: Windows v Linux.
2022-03-07 (first published: 2017-02-07)
422 reads
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
117 reads
Is the Time of the DBA Ending?
The DBA role might be changing, but Steve thinks this creates opportunities.
2022-03-04
422 reads
The Test Mistake
Many developers have made mistakes that in test and development environments that customers notice. Using DevOps should help reduce these issues.
2022-03-02
216 reads
Less is More
In some ways the world changes a lot; in others, it's very much the same. Steve notes that often change brings opportunities, if you can adapt.
2022-02-28
163 reads
Another look at table variables
Becoming overly enthusiastic about a new SQL Server feature can backfire if you don’t do some testing. One example is the table variable introduced with SQL Server 2000. At the time, there was a myth that table variables would always perform better than temp tables with the reasoning that, by definition, variables are stored in […]
2022-02-26
424 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...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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