A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
215 reads
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
20 reads
Are you ready to take your SQL skills for a spin? The August 2024 SQL Practice is here to offer you a fun, hands-on learning experience. Designed with real-world...
2024-08-26 (first published: 2024-08-12)
370 reads
Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.
2024-08-09
41 reads
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
380 reads
I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...
2024-08-23 (first published: 2024-08-09)
377 reads
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
181 reads
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
34 reads
hiddled – adj. feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....
2024-08-09
33 reads
Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...
2024-08-08
29 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Comments posted to this topic are about the item SSRS Reminded Me of the...
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