Snowflake Data Cloud
Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of...
2022-07-06
168 reads
Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of...
2022-07-06
168 reads
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
31 reads
Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the...
2022-07-06 (first published: 2022-07-04)
85 reads
I don’t think I’m going too far out on a limb to call Kevin Kline a friend. I’m extremely humbled and honored that I can say that. Kevin is...
2022-07-06
16 reads
This procedure can get you the list of queries being executed frequently and for duration greater/less than a particular time. You may also find it very useful if you...
2022-07-06
35 reads
This procedure will get all the objects performing committed reads. It will fetch all the objects (Procedures, Functions, Triggers, View etc.) that doesn't uses the NOLOCK and SET ISOLATION...
2022-07-06
29 reads
This procedure will get all the stored procedures and triggers missing the use of SET NOCOUNT ON. It may be helpful in performance tuning assignments.
2022-07-06 (first published: 2022-07-04)
36 reads
The problem
In this scenario, you have discovered that one of your Check constraints or Foreign keys is not trusted.
Maybe you’ve detected it with a sp_Blitz, dbachecks or out of...
2022-07-06 (first published: 2022-06-24)
349 reads
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming for 3 posts a week, and mostly keeping there, but it’s created a little stress...
2022-07-05
27 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-05
10 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
Comments posted to this topic are about the item Ingesting Data From REST API...
Comments posted to this topic are about the item Separate Reads
Comments posted to this topic are about the item The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers