Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
521 reads
Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...
2020-08-10 (first published: 2020-07-29)
537 reads
Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...
2020-08-03 (first published: 2020-07-22)
262 reads
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
11 reads
Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.
2020-06-05 (first published: 2016-05-17)
18,229 reads
Watch this week’s video on YouTube. This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on...
2020-01-14 (first published: 2020-01-07)
272 reads
Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...
2019-12-17
132 reads
Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...
2019-12-09 (first published: 2019-11-26)
1,868 reads
Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...
2019-12-03
1,550 reads
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive the experience.
2019-11-12
7 reads
By Arun Sirpal
A very common approach is to query data straight from Databricks via Power BI....
By Will Assaf
Honored to be a part of not just SQLSaturday #1000, but the long proud...
By Steve Jones
This post looks at how to re-configure a local Azure DevOps agent when you...
Hi, Sorry if I couldn't find the correct section to post my question. I...
Hi, Sorry if I couldn't find the correct forum to post my question. I...
select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus...
Ask SSC