The PASS Summit 2022 DevOps Devour Hour from Redgate
At the Data Community Summit this year, Redgate is hosting a couple of lunchtime sessions, the Summit 2022 DevOps Devour Hour. A creative name, for sure. These are Thursday...
2022-11-03
21 reads
The Voice of the DBA
Daily Coping 3 Nov 2022
Today’s coping tip is to ask yourself, will this matter a year from now? It’s easy to get caught up in short term things. I’m behind on a few...
2022-11-03
13 reads
Create a Community Event at the Summit
There are a few community events at the Summit this year, but fewer than in the past. I know we’re all rebooting our conference experiences, and that can make...
2022-11-02
12 reads
Daily Coping 2 Nov 2022
Today’s coping tip is to be kind to yourself today. Remember, progress takes time. I am usually good at this. I work on many things that take time, so...
2022-11-02
13 reads
Getting Started Speaking – #NewStarNovember
My journey might be somewhat unusual, but perhaps not. I started writing articles on the Internet at a few different places before I started SQL Server Central. There were...
2022-11-14 (first published: 2022-11-01)
91 reads
SQL Kilts #SeattleSummitMoments
This is another memory of the PASS Summit, this one an idea from Grant Fritchey, who wanted support the Women in Technology (WIT) events. And have a few laughs...
2022-11-01
36 reads
Daily Coping 1 Nov 2022
Today’s coping tip is to be kind to yourself. Remember progress takes time. I’ve spent most of this year trying to better manage my weight and become healthier. I...
2022-11-01
15 reads
Paid Flyway Advantages–Undo and Check
The Community edition of Flyway has some nice basic features, and it works well for many people. However, it requires you to do a lot of the heavy lifting...
2022-10-31
164 reads
T-SQL Tuesday #155 Round Up
It’s time to look back at the 155th blog party. I was the host this month, asking about Dynamic SQL. I got quite a few responses, which I’ve gone...
2022-11-01 (first published: 2022-10-31)
14 reads
Daily Coping 31 Oct 2022
Today’s coping tip is to find a new perspective on a problem you face. I don’t face many big problems, but I do face lots of small ones on...
2022-10-31
13 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