The Poor Soul
What should those accidental DBAs do when they don't get any training, but they are responsible for database servers? Steve Jones has a few pieces of advice today.
2015-10-15 (first published: 2011-05-11)
491 reads
What should those accidental DBAs do when they don't get any training, but they are responsible for database servers? Steve Jones has a few pieces of advice today.
2015-10-15 (first published: 2011-05-11)
491 reads
A quick tip to help you get the most out of SQL Prompt.
2015-10-14 (first published: 2012-05-01)
1,675 reads
Filegroups are a feature of SQL Server that most people don't use, but they can help you to better manage your databases as your data requirements grow larger and larger.
2015-10-13 (first published: 2011-05-12)
731 reads
I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...
2015-10-13 (first published: 2015-09-30)
4,153 reads
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
749 reads
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
439 reads
2015-10-09 (first published: 2014-03-21)
5,006 reads
Today Steve Jones asks about your job and if you get to pick the things you work on or is most of your time assigned to tasks by someone else?
2015-10-08 (first published: 2011-05-13)
251 reads
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
396 reads
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
564 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
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