Bert Wagner

Bert Wagner is a Business Intelligence Developer at Progressive Insurance. He enjoys solving challenging data transformations with T-SQL and optimizing for query performance. In addition to BI development, Bert loves building ASP.NET MVC web apps and building Internet of Things projects.

All authors

10 Questions To Spark Conversation At Your Next SQL Event

by Bert Wagner

Bert Wagner

Photo by rawpixel.com on UnsplashHere’s a word for word transcription of a conversation I’ve had a hundred times over:
“Hi I’m Bert. What do...

2017-10-24

176 reads

10 Questions To Spark Conversation At Your Next SQL Event

by Bert Wagner

Bert Wagner

Photo by rawpixel.com on Unsplash
Here's a word for word transcription of a conversation I've had a hundred times over:

"Hi I'm Bert. What do you do?"
"I'm ____ and I'm a SQL developer."
"That's cool,...

2017-10-24

9 reads

How to Make SQL Server Act Like A Human By Using WAITFOR

by Bert Wagner

Bert Wagner

Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...

2017-10-17

199 reads

How to Make SQL Server Act Like A Human By Using WAITFOR

by Bert Wagner

Bert Wagner

Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...

2017-10-17

8 reads

How NOLOCK Will Block Your Queries

by Bert Wagner

Bert Wagner

Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...

2017-10-10

387 reads

How NOLOCK Will Block Your Queries

by Bert Wagner

Bert Wagner

Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...

2017-10-10

10 reads

3 Tips You Need To Know When Using PowerShell with SQL Server

by Bert Wagner

Bert Wagner

Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...

2017-10-03

146 reads

3 Tips You Need To Know When Using PowerShell with SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...

2017-10-03

5 reads

Clustered vs Nonclustered: Index Fundamentals You Need To Know

by Bert Wagner

Bert Wagner

Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...

2017-09-26

1,548 reads

Clustered vs Nonclustered: Index Fundamentals You Need To Know

by Bert Wagner

Bert Wagner

Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...

2017-09-26

8 reads

All authors

Bert Wagner

10 Questions To Spark Conversation At Your Next SQL Event

10 Questions To Spark Conversation At Your Next SQL Event

How to Make SQL Server Act Like A Human By Using WAITFOR

How to Make SQL Server Act Like A Human By Using WAITFOR

How NOLOCK Will Block Your Queries

How NOLOCK Will Block Your Queries

3 Tips You Need To Know When Using PowerShell with SQL Server

3 Tips You Need To Know When Using PowerShell with SQL Server

Clustered vs Nonclustered: Index Fundamentals You Need To Know

Clustered vs Nonclustered: Index Fundamentals You Need To Know

Blogs

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

ADF Pipeline Debugging Fails with BadRequest – The Sequel

Forums

Dynamic Unpivot

Writing as an Art and a Job

String Similarity II

Question of the Day

String Similarity II