Small Data SF 2024
I can’t remember how I heard about Small Data SF 2024, but it caught my eye. The mix of sessions had me interested in going, especially with Mother Duck...
2024-10-04
65 reads
Blog Posts
Small Data SF 2024
I can’t remember how I heard about Small Data SF 2024, but it caught my eye. The mix of sessions had me interested in going, especially with Mother Duck...
2024-10-04
9 reads
Enabling an Index: #SQLNewBlogger
I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...
2024-10-02
16 reads
Microsoft Purview GA menu’s
The new data governance features in Microsoft Purview are now being made generally available as they are gradually rolled out across various regions. You can view the deployment schedule...
2024-10-02 (first published: 2024-09-19)
168 reads
Back to Boston for SQL Saturday
I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...
2024-10-01
29 reads
Back to Boston for SQL Saturday
I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...
2024-10-01
9 reads
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
Most of us who work with data have, at least a few times, been presented with a challenge to explore and attempt to make sense of a poorly-defined set...
2024-10-01
38 reads
Comparing an Old Running Total to Window Functions
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
138 reads
Comparing an Old Running Total to Window Functions
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
9 reads
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-09-30
9 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 KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
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