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 Stored Procedures vs Functions vs Views

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....

2019-11-04 (first published: 2019-10-22)

1,332 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

459 reads

Are Stored Procedures Faster Than Stand-Alone Queries?

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a...

2019-10-24 (first published: 2019-10-15)

1,163 reads

Communicating Effectively at the Workplace

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-10-10 (first published: 2019-10-08)

373 reads

More “Wrong” SQL Server Math – Floating Point Errors

• by Bert Wagner

• Bert Wagner

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

154 reads

SQL Server Quick Tips

• by Bert Wagner

• Bert Wagner

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)

871 reads

SQL Server’s “Wrong” Math

• by Bert Wagner

• Bert Wagner

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

45 reads

Tracking Who Last Changed a Row

• by Bert Wagner

• Bert Wagner

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

Whitespace, Letter Case, and Other Things That Prevent Plan Reuse

• by Bert Wagner

• Bert Wagner

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)

473 reads