Daily Coping 29 Dec 2022
Today’s coping tip is to ask for help and let someone else discover the joy of giving. I do most of the cooking in the house, but I thought...
2022-12-29
14 reads
The Voice of the DBA
Solar Projection v Estimates
We got a solar system in 2022 to try and fix some of our power costs and hedge against the future. We were fairly confident it would work well,...
2023-01-06 (first published: 2022-12-28)
259 reads
Daily Coping 28 Dec 2022
Today’s coping tip is to look for something positive to say to everyone you speak to. This works well during the holiday season as most people are in a...
2022-12-28
14 reads
Join me at VS Live Las Vegas 2023
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
45 reads
More DevOps with the SQL Solutions Group
I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group. You can register here and reserve a spot. Scott Klein and I did a webinar last...
2022-12-27
39 reads
Daily Coping 27 Dec 2022
Today’s coping tip is to share a happy memory or inspiring thought with a loved one. This is a memory for me: This came up in a Google Photo...
2022-12-27
18 reads
My Stats from 2022
I wrote last week about my travel, 23 trips in 2022. However, I’ve been gathering some other stats about my life and what I do, so I wanted to...
2022-12-26
21 reads
Daily Coping 26 Dec 2022
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
18 reads
A Big Year for Travel
I do tend to travel a good amount as my kids have gotten older. The pandemic slowed things for a year, but only then. Someone remarked on this year...
2022-12-23
15 reads
Daily Coping 23 Dec 2022
Today’s coping tip is to be generous. Feed someone with food, love, or kindness today It’s often a family day today, as work ends and we prepare for Christmas....
2022-12-23
16 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...
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
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...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers