SQL Saturday Chicago: I’m speaking
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?...
2018-02-19
255 reads
Confessions of a Microsoft Addict
STORPORT: Reading an ETL trace
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,633 reads
PaaS and the ever changing role of the DBA
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...
2017-12-26 (first published: 2017-12-12)
1,659 reads
How to be a successful innovator
Let’s say you have some obscure list of career goals for the year and one of those is to be...
2017-11-09
314 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
361 reads
Don’t forget to drop your views
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...
2017-10-02 (first published: 2017-09-25)
2,791 reads
SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...
2017-09-22
414 reads
Offtopic: Lifehack: Old tech has many purposes
For those that don’t know, I live in Texas. Been here all my life. There are two main things north...
2017-09-15 (first published: 2017-09-11)
1,622 reads
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,764 reads
Thank you for Microsoft MVP
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....
2017-09-02
374 reads
Blogs
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...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
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...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers