My Toolbox - SSMS
No matter how hard Azure Data Studio (ADS) is pushed by Microsoft, most DBAs still use SQL Server Management Studio (SSMS). In this blog post, I’ll go through my...
2024-08-14 (first published: 2024-08-03)
883 reads
A New Word: Bareleveling
bareleveling – v. trying to improve yourself without anyone else knowing about it, afraid that they’ll think it’s silly or grandiose or unnecessary, or that they’’ll end up calling...
2024-08-02
30 reads
Welcome to the Fediverse Files: What Is the Fediverse?
Have you heard the term "fediverse" and wondered what the heck it is? Doc Pop is here to explain. And no, it's not a cheese pun.
2024-08-02
47 reads
SQL Training: The Hidden Engine Driving Business Growth
In the digital age, data is the new gold, but it's worthless if you can't understand and use it. That's where SQL (Structured Query Language) comes in. SQL is...
2024-08-02
39 reads
Kilt Day!
This is a quick blog post to announce that I am reviving Kilt Day at PASS Data Community Summit. Over the last few years… ah hell, let’s just say...
2024-08-16 (first published: 2024-08-01)
140 reads
Finding Where xp_cmdshell is Used
I saw a post recently where someone was concerned about where xp_cmdshell was in use inside their system. They felt it was a security risk, and decided to get...
2024-08-14 (first published: 2024-07-31)
606 reads
Building Studio in Public: Using WordPress Components and Tailwind CSS in our Local Development App
Here's how we used WordPress Components and Tailwind CSS to build our local development app, Studio.
2024-07-31
45 reads
Tech in 2030
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
132 reads
Data (and Humans) At Rest
We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...
2024-08-12 (first published: 2024-07-30)
188 reads
Why We’re Partnering With Perplexity
The short answer is: You’ll be eligible for a piece of the pie, plus increased traffic to your website.
2024-07-30
20 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers