Bert Wagner

Recursively Querying Row Groups

• by Bert Wagner

• Bert Wagner

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)

524 reads

Should I Transform My Data In My SQL Query?

• by Bert Wagner

• Bert Wagner

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)

539 reads

Moving 1/3 of a heap

• by Bert Wagner

• Bert Wagner

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)

263 reads

COMING SOON – New Content

• by Bert Wagner

• Bert Wagner

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

Using Python And NetworkX To Build A Twitter Follower Recommendation Engine

• by Bert Wagner

• Bert Wagner

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

SQL Server Converts Numbers to Asterisks

• by Bert Wagner

• Bert Wagner

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

137 reads

Azure SQL vs Azure Table Storage

• by Bert Wagner

• Bert Wagner

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,590 reads

When a SQL UPDATE Statement DELETES Rows

• by Bert Wagner

• Bert Wagner

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,880 reads

First Time Speaking at PASS Summit

• by Bert Wagner

• Bert Wagner

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

SQL Server 2019 Feature Power Rankings

• by Bert Wagner

• Bert Wagner

Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...

2019-10-29

531 reads