Social Anxiety and Events Like the PASS Summit
If you are an introvert like me, events like the PASS Summit can call forth your social anxiety. I know this past week, I definitely felt it, even though...
2024-11-11
71 reads
Blog Posts
A New Word: Skidding
skidding – v. intr. the practice of making offhand comments that sound sarcastic but are actually sincere and deeply felt. I used to make lots of sarcastic comments. Some...
2024-11-08
23 reads
PASS Summit – Thursday
Let’s start with the keynote. The biggest take away was how having to support multiple data platforms is growing and becoming the norm. This has been my experience and...
2024-11-08
30 reads
Tell me the positives of your solution
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
171 reads
Using SQL Compare in Read-Only Databases
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-08 (first published: 2024-10-21)
187 reads
PASS Summit 2024 – Wednesday
A common theme in the PASS Summits I've attended is community and that's definitely true this year. It's one of the reasons I have loved coming when I can....
2024-11-07
40 reads
Taming Database Challenges: Insights from Redgate Keynote
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying Complexity – Making the Database Work in the Real World. As the database landscape grows...
2024-11-07
31 reads
Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
2024-11-06 (first published: 2024-10-27)
428 reads
PASS Summit 2024 – A Very Different World
The last data centric conference I attended was the PASS Summit in 2019. A few months later, much of the world went on lockdown due to COVID. Since then,...
2024-11-06
28 reads
Using Copilot to help me update SQL Saturday
An interesting AI experiment here with Copilot from GitHub in handling some code I don’t work with that often. Read on and watch. This is part of a series...
2024-11-06 (first published: 2024-10-16)
359 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