A New Word: 1202
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you need to do, you feel too guilty to put anything off until later, prioritizing every...
2024-03-29
41 reads
Blog Posts
Dear Women in Tech, You Can Present at EightKB, Too
Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise....
2024-03-29 (first published: 2024-03-21)
175 reads
Speaking at dataMinds Saturday & Techorama 2024
I have the pleasure to announce I’ll be presenting at two conferences this spring. The first one is at dataMinds Saturday 2024 (back in-person!): Yes, it’s a long abstract...
2024-03-29 (first published: 2024-03-20)
99 reads
Webcast: How to Secure SQL Server – End to End Security
On April 16, 2024, I will be giving another webcast; this one will be on SQL Server security. Sign up link As always, the registration is free. Here’s the...
2024-03-29
106 reads
Working with ALS – Insights from the Ability Summit
The 14th annual Ability Summit is a global event that I attended a few weeks ago. It is hosted by Microsoft, and it presents the latest technology innovations and...
2024-03-29 (first published: 2024-03-27)
30 reads
DevOps: It’s About the Team, Not Just the Tech
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
204 reads
What Does Redgate Test Data Manager Do?
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to...
2024-03-27 (first published: 2024-03-18)
148 reads
Change Notebook Spark Session Time-Out in Microsoft Fabric
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric and suddenly you have to leave your workstation for a while. Someone ran the doorbell...
2024-03-25 (first published: 2024-03-16)
133 reads
Extracting PostgreSQL database metadata for presentation in Excel format
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks for more than half of my life. I believe it's the most widely used spreadsheet...
2024-03-25 (first published: 2024-03-16)
268 reads
Tomorrow – Webcast on SQL Server Administration
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-25
24 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 JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
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