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

“How do I contribute to dbatools?” with Drew Furgiuele

by Bert Wagner

Bert Wagner

This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...

2018-02-06

111 reads

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,996 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

11 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

444 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

14 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

15 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,164 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,708 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

390 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

9 reads

All authors

Bert Wagner

“How do I contribute to dbatools?” with Drew Furgiuele

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?

Blogs

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Learn From History

The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

Question of the Day

The SQL Server MCP Server