Azure Storage Replication Types
Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...
2022-06-15
76 reads
Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
90 reads
T-SQL Tuesday 151: T-SQL Coding Standards
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
60 reads
Daily Coping 14 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-14
20 reads
Who is Updating That Table? – SQL Audit
I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record. Our team discussed the best...
2022-06-14
179 reads
T-SQL Tuesday #151 Coding Standards
This month the T-SQL Tuesday blog party is hosted by my good friend, Mala. This is her fourth time hosting and she has a good topic this time. While...
2022-06-15 (first published: 2022-06-14)
62 reads
Coding Standards (T-SQL Tuesday #151)
Foreword
This month’s invitation is from Mala Mahadevan, and it’s about coding standards. Fortunately, I may forget several basic ones because my team probably eradicated them long ago.
I’ll go with...
2022-06-14
16 reads
2022 State of PostgreSQL Survey
Hello all. I know most of you are still working within SQL Server. However, a few of you are become more like me, hybrid data managers, working in more...
2022-06-13
16 reads
Refreshing Tables in Data Masker
Data Masker for SQL Server is a product that helps to change data for compliance purposes. It works well, but it isn’t intuitive in a few ways. We bought...
2022-07-01 (first published: 2022-06-13)
170 reads
Daily Coping 13 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-13
13 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