In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
610 reads
nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...
2023-12-15
51 reads
I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw...
2023-12-15 (first published: 2023-11-27)
402 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking about SQL Server on Linux.
2023-12-15 (first published: 2023-11-28)
209 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...
2023-12-13 (first published: 2023-11-29)
327 reads
I presented “Microsoft Fabric for Dummies” at Cloudbrew and “How I saved 80% on my ADF costs” as a lightning talk at Data Meetup Groningen. Both slidedecks can be...
2023-12-13
14 reads
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******...
2023-12-13 (first published: 2023-11-27)
700 reads
SQL Server 2022 introduces an exciting feature: the ability to access the Query Store from a secondary replica in an Availability Group. This enhancement offers a significant advantage, allowing...
2023-12-11 (first published: 2023-11-22)
366 reads
I have curated the list of activities of a DBA or one can say Job Description of a DBA. DBA needs to adapt and keep learning new technologies
The...
2023-12-11 (first published: 2023-11-27)
1,851 reads
giltwrights – n. the imaginary committee of elders that keeps a running log of your mistakes, steadily building their case that you’re secretly a fraud, a coward, a doofus,...
2023-12-08
50 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
hi , a new user wants to be able to add sql agent jobs...
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
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