Daily Coping Tip 11 Nov 2022
Today’s coping tip is to make a list of new things you want to do before the end of the year. Hmm, definitely some things to do, but what’s...
2022-11-11
13 reads
Blog Posts
I'm speaking at PASS Data Community Summit 2022
Looking forward to speaking in Seattle at next week's PASS Data Community Summit by Redgate. I'll be speaking both as a representative of my role on the Microsoft Database...
2022-11-11
13 reads
Improved data loads from Snowflake to Azure Synapse Analytics
My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires us to shift data from a Snowflake...
2022-11-11 (first published: 2022-10-30)
169 reads
Off to the Summit and SQL Saturday Oregon
I’m traveling this morning. My second to last trip of the year, and another long one. Today through the 20th I’ll be in Portland and Seattle. First is Portland,...
2022-11-11
28 reads
Setting up my new workstation with some Chocolatey goodness.
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
188 reads
SQL Server 2022 Query Performance Tuning
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
258 reads
Attending and presenting at conferences
I have attended and presented at a ton of conferences over the years (see the entire list at Presentations | James Serra’s Blog). If you are looking to learn...
2022-11-10
16 reads
Daily Coping 10 Nov 2022
Today’s coping tip is to respond to a difficult situation in a different way. There are plenty of difficult situations I find myself in, some of which create lots...
2022-11-10
12 reads
Thursday is #sqlkilt Day
At the PASS Data Community Summit, Thursday is the day when the Women in Technology (WIT) luncheon takes place. This is an event I’ve come to enjoy as I...
2022-11-10
77 reads
Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
16 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