Watch this week’s episode on YouTube. Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren’t aware of how...
2019-10-01
263 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
994 reads
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
57 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
2 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
1 reads
This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-19 (first published: 2019-09-10)
1,129 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
3 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....
2019-09-16 (first published: 2019-09-03)
521 reads
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,794 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...
I am using the following sql to convert rows into columns for each pid,...
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
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers