A New Word: Mornden
mornden – n. the self-container pajama universe shared by two people on a long weekend morning, withdrawing from the world and letting the hours slow to a crawl, coming...
2024-11-22
28 reads
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie or already know some SQL, this sale has awesome learning options at prices you won't...
2024-11-22
45 reads
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have (relatively) large dbs (compared to prod). Enter the pgstattuple...
2024-12-02 (first published: 2024-11-21)
195 reads
Living with Chronic Suicidal Thoughts: A Personal Reflection
For as long as I can remember—since I was 16 or even earlier—chronic suicidal thoughts have been an unrelenting presence in my life. They’re not
The post Living with Chronic...
2024-11-20
4 reads
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all who posted on this topic! Here are the highlights of the posts (in alphabetical order...
2024-11-21 (first published: 2024-11-20)
132 reads
Using SQL Compare with Read-only Access
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-29 (first published: 2024-11-20)
348 reads
Off to Live 360
I am off to Live 360 today, on my last trip of the year. I’m excited to deliver two presentations tomorrow (VSTH03 and VSTH12), but a little sad this...
2024-11-20
18 reads
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance Best Practices (Amazon link), which means I got a copy for free. The book is...
2024-11-29 (first published: 2024-11-19)
207 reads
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless) Availability Group to seed a database from a Windows SQL instance into a pod in...
2024-12-02 (first published: 2024-11-19)
256 reads
Introducing SQL Server 2025 - Enterprise Ready AI
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming release focused on AI, analytics, and modern database development, backed by innovations in mission-critical engine...
2024-11-27 (first published: 2024-11-19)
781 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 BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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