A New Word: Fitzcarraldo
fitzcaraldo – n. a random image that becomes lodged deep in your brain – maybe washed there by a dream, or smuggled inside a book, or planted during a...
2023-07-28
29 reads
Blog Posts
Creating a Speaking Failures Support Group
Earlier this week the emails went out to speakers who submitted to the PASS Data Community Summit 2023 conference. These were acceptances and rejections, letting people know the results...
2023-07-28 (first published: 2023-07-13)
155 reads
The two hardest concepts of security are Who? and Where?
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading
2023-07-28 (first published: 2023-07-13)
315 reads
I’m back! I’m still a Microsoft Data Platform MVP. And other minor life updates.
I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading
2023-07-27
38 reads
Code that made you feel a certain way : T-SQL Tuesday #164
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
366 reads
T-SQL Tuesday #164: Code that makes you feel
The invitation this month is from Erik Darling, and it’s a neat one. I like this thought, asking us to find code that impressed us or made us feel...
2023-07-26 (first published: 2023-07-11)
448 reads
100 Blog Posts Milestone
Good morning dear reader, Long time no talk. It has been a jam-packed and chaotic first half of 2023 for my family and me. The first quarter of the...
2023-07-25
55 reads
Test Restore Your SQL Server Databases
Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...
2023-07-25
308 reads
A Security Change with SQL Compare 15
Actually, this is a change for many products and software that connects to SQL Server. Updated drivers require us to now decide to trust the server certificate. I opened...
2023-07-24
132 reads
Early Bird Pricing for the Data Community Summit Ends Jul 26
The early bird pricing for the PASS Data Community Summit ends this week, on Jul 26. After that, there is a bump, so let you boss know this is...
2023-07-24
35 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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 BCA KCP Saharjo Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
BCA KCU BLOK A CIPETE Tlp,Cs:0821-8154-393
WA:08218154393 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...
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