A Good Cause #SeattleSummitMoments
This is another memory of the PASS Summit, this one inspired by Argenis Fernandez, who wanted to raise money for Doctors Without Borders. I wrote a bit about the...
2022-10-28
14 reads
The Voice of the DBA
I Hope Someone Brings Back Game Night
A few years ago at the Summit, Andy Warren and I set up a Game night. We convinced the organizers to give us a room for a few hours...
2022-10-28
12 reads
Daily Coping 28 Oct 2022
Today’s coping tip is to realize you can’t do everything; what are your three top priorities now? It’s a few weeks before the Data Community Summit, volleyball starts, vacation...
2022-10-28
5 reads
Daily Coping 27 Oct 2022
Today’s coping tip is to write down three specific things that have gone well recently. Easy, as a lot of things have gone well. I’m going with some travel...
2022-10-27
12 reads
Daily Coping 26 Oct 2022
Today’s coping tip is to recognize that you have a choice in what to prioritize A good one for me, especially as I’m a little stressed and overloaded with...
2022-10-26
15 reads
The SQL Server Central Casino Party #SeattleSummitMoments
Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of...
2022-11-07 (first published: 2022-10-25)
898 reads
Daily Coping 25 Oct 2022
Today’s coping tip is to share a helpful quote, picture, or video with a friend. I usually enjoy sharing quotes with friends on their birthdays. Those of you who...
2022-10-25
13 reads
Daily Coping 24 Oct 2022
Today’s coping tip is to find joy in tackling something that you have put off. I on not a bad procrastinator, but I do put plenty of things off....
2022-10-24
11 reads
From Manual to DevOps at the Data Community Summit
This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
118 reads
Daily Coping 21 Oct 2022
Today’s coping tip is to do something constructive to improve a difficult situation. My life is amazing, but there are certainly some difficult times. Sometimes at work, sometimes at...
2022-10-21
15 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers