Ever since the release of Always On Availability Group (AG or HADR) in SQL Server 2012 the adoption ratio is increasing. A lots of my clients too are adopting...
2024-01-03 (first published: 2023-12-25)
4,420 reads
Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and not others. I don’t recommend this, but a customer was doing this and I wanted...
2023-12-22
17 reads
whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as...
2023-12-22
40 reads
While I was at a conference recently, someone asked me about the Scripts Folder feature in SQL Compare and how to set that up. This post just looks at...
2024-01-05 (first published: 2023-12-20)
551 reads
A couple of months ago where I work, a major product started undergoing a rebrand. I don’t pretend to understand marketing folks, but a change this big needed to...
2023-12-19
464 reads
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading
2023-12-29 (first published: 2023-12-19)
295 reads
I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...
2023-12-29 (first published: 2023-12-18)
486 reads
📰 News What happened in the DAX world in 2022 New DAX functions… in 2022 The Microsoft Learn Cloud Skills Challenge Microsoft Ignite edition is back! How to build...
2023-12-18
36 reads
Recently I was working with Flyway Desktop (FWD) and helping a customer work on deploying part of their work. They weren’t sure how easy this could be, but this...
2023-12-27 (first published: 2023-12-15)
144 reads
When I first started working with SQL on Linux one of the first things I did was to remove the default the [BUILTINAdministrators] login. This is pretty much standard...
2023-12-27 (first published: 2023-12-15)
263 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
While doing some housekeeping I came across a folder containing some scripts that appear...
Comments posted to this topic are about the item Why SQL Server Database Attach...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers