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

FizzBuzz and Multiple Recursive Member CTEs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...

2018-08-21

9 reads

FizzBuzz and Multiple Recursive Member CTEs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...

2018-08-21

10 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...

2018-08-16 (first published: 2018-07-31)

3,720 reads

6 Techniques For Troubleshooting Your Code

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2018-08-14

2 reads

6 Techniques For Troubleshooting Your Code

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday #105 prompt by Wayne Sheffield. T-SQL Tuesday is a way for the SQL Server community to share ideas about...

2018-08-14

9 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...

2018-08-07

7 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...

2018-08-07

373 reads

Displaying Long Values in SSMS

by Bert Wagner

Bert Wagner

2018-08-07

13 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...

2018-07-31

7 reads

Should You Use Index Hints?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...

2018-07-31

7 reads

All authors

Bert Wagner

FizzBuzz and Multiple Recursive Member CTEs

FizzBuzz and Multiple Recursive Member CTEs

Should You Use Index Hints?

6 Techniques For Troubleshooting Your Code

6 Techniques For Troubleshooting Your Code

Displaying Long Values in SSMS

Displaying Long Values in SSMS

Displaying Long Values in SSMS

Should You Use Index Hints?

Should You Use Index Hints?

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

Apakah cs Qlola bri punya wa

Call center Qlola bri

Layanan wa cs Qlola bri

Question of the Day

How Long is a Long I/O?