DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be ... Continue reading
2019-11-18
38 reads
Blog Posts
How to get the Active Directory user password policy values
Recently I have had to troubleshoot quite a bit of SQL login issues and often times the issue was with the users active directory user account.I was aware the...
2019-11-18
1,144 reads
SQLSaturday Orlando Notes – Room Location
We hold our event at a local college. The way it works is our contact tries to reserve ALL of the rooms in the building because we will end...
2019-11-18
11 reads
What SQL Server Agent Alerts Do I have setup?
I am in a situation where I have to incorporate SQL Server Agent alerts in my monitoring and alerting strategy.I needed a query (DMV) to get details on what...
2019-11-18 (first published: 2019-11-07)
671 reads
2019-11-16
14 reads
2019-11-16
9 reads
Getting Started with SQL Prompt 10
This week we released SQL Prompt 10, which is an exciting milestone for us. I remember when I discovered this little gem for Database Weekly and sent it over...
2019-11-15
130 reads
Rounding Out PASS Summit 2019
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
439 reads
The Right Consultant Is Worth All The Money
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer...
2019-11-15
5 reads
The SQLSaturday pitch to host facilities
Not being able to find a good, affordable venue to host a SQLSaturday is a show-stopping problem that is common to a lot of events, especially SQLSaturdays getting started...
2019-11-15 (first published: 2019-11-05)
190 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 BCA KCP Palmerah Tlp:08218154393
WA:08218154393 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
ALAMAT KONTAK BCA KCP Bintaro Tlp:08218154393
WA:08218154393 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
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