Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...
2022-10-03
27 reads
Blog Posts
Putting counters in names
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
575 reads
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
115 reads
Community Tools Month 2022 - dbatools
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September Community Tools Awareness Month.
In September, I want you to improve community knowledge about one free...
2022-10-01
133 reads
Daily Coping 30 Sep 2022
Today’s coping tip is to find a new way to use one of your strengths or talents. I asked someone for strengths recently. Most of those items are things...
2022-09-30
13 reads
Data lake architecture
I have had a lot of conversations with customers to help them understand how to design a data lake. I touched on this in my blog Data lake details,...
2022-09-30
48 reads
DELETE TOP x rows with an ORDER BY
This was an interesting question that I was asked yesterday and something that I’d never really thought of before. Can you delete the top x number of rows based...
2022-09-30 (first published: 2022-09-15)
991 reads
The Redgate 100
The Redgate 100 is a list of 100 people that are influential in the database world in a number of categories.I made the list in a few places, which...
2022-09-30 (first published: 2022-09-09)
174 reads
Daily Coping 29 Sep 2022
Today’s coping tip is to avoid saying “I should” and make time to do nothing, or do something fun. I’m writing this ahead of time, and I am doing...
2022-09-29
12 reads
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as...
2022-09-29
27 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers