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

The Fastest Way To Locate Errors In Your SQL Query

by Bert Wagner

Bert Wagner

Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...

2018-01-30

1,951 reads

The Fastest Way To Locate Errors In Your SQL Query

by Bert Wagner

Bert Wagner

In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...

2018-01-30

6 reads

Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule

by Bert Wagner

Bert Wagner

Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...

2018-01-23

442 reads

Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule

by Bert Wagner

Bert Wagner

Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...

2018-01-23

8 reads

Importing GeoJSON Earthquake Data Into SQL Server

by Bert Wagner

Bert Wagner

A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...

2018-01-16

5 reads

Importing GeoJSON Earthquake Data Into SQL Server

by Bert Wagner

Bert Wagner

A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...

2018-01-16

1,125 reads

A Better Way To Script Database Objects

by Bert Wagner

Bert Wagner

Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...

2018-01-09 (first published: 2018-01-02)

3,621 reads

I Have A SQL Login – Why Can’t I Connect?

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday...

2018-01-09

387 reads

I Have A SQL Login - Why Can't I Connect?

by Bert Wagner

Bert Wagner

This post is a response to this month's T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...

2018-01-09

4 reads

A Better Way To Script Database Objects

by Bert Wagner

Bert Wagner

Happy New Year! My New Year's resolution for 2018 is to help you become a better SQL developer.
I want to start off with that today by showing you a...

2018-01-02

6 reads

All authors

Bert Wagner

The Fastest Way To Locate Errors In Your SQL Query

The Fastest Way To Locate Errors In Your SQL Query

Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule

Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule

Importing GeoJSON Earthquake Data Into SQL Server

Importing GeoJSON Earthquake Data Into SQL Server

A Better Way To Script Database Objects

I Have A SQL Login – Why Can’t I Connect?

I Have A SQL Login - Why Can't I Connect?

A Better Way To Script Database Objects

Blogs

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Claude AI Convinced Me Not to Build an iPad App

Forums

SSMS 22 Latest Update Crashing

Transactional Replication setup issue

The Power of Data and Privacy

Question of the Day

What's the Date?