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

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

2018-06-12

9 reads

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...

2018-06-12

10 reads

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
When I started working with T-SQL, I thought the GO command was optional, kind of...

2018-06-08 (first published: 2018-05-29)

3,456 reads

4 Ways To Define Lookup Values In A Query

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...

2018-06-05

3 reads

4 Ways To Define Lookup Values In A Query

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...

2018-06-05

22 reads

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...

2018-05-29

7 reads

What Does The GO Command Do?

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...

2018-05-29

9 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am...

2018-05-28 (first published: 2018-05-22)

3,796 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...

2018-05-22

9 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...

2018-05-22

5 reads

All authors

Bert Wagner

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class

What Does The GO Command Do?

4 Ways To Define Lookup Values In A Query

4 Ways To Define Lookup Values In A Query

What Does The GO Command Do?

What Does The GO Command Do?

Converting JSON to SQL Server CREATE TABLE Statements

Converting JSON to SQL Server CREATE TABLE Statements

Converting JSON to SQL Server CREATE TABLE Statements

Blogs

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

Ola Hallengren Index Optimize Maintenance can we have data compression = page

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Question of the Day

String Similarity I