I almost missed this month, so this is also a good #SQLNewBlogger post. I thought about it for a few minutes as I ate breakfast at my desk and...
2024-07-26 (first published: 2024-07-09)
298 reads
On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...
2024-07-22 (first published: 2024-07-09)
365 reads
I had a lot of local branches for a repo (actually a few repos). I know these are old and not used anymore, so how do I delete them?...
2024-07-08
33 reads
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
33 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've been yearning for a risk-free environment to test, experiment, and refine your SQL queries against...
2024-07-17 (first published: 2024-07-06)
374 reads
Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there...
2024-07-22 (first published: 2024-07-05)
347 reads
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly captures the kind of person you are, tying together your many flaws and contradictions into...
2024-07-05
35 reads
I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues...
2024-07-15 (first published: 2024-07-04)
755 reads
I love QuickieStore, but I wanted some columns to be at the front end of the results returned. Namely, I wanted top_waits, query_sql_text, and query_plan right after database name....
2024-07-15 (first published: 2024-07-03)
310 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...
2024-07-03
77 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...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers