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

113 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

2,013 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

15 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

448 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

18 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

20 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,179 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,727 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

394 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

15 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

The Book of Redgate:A Prehistory

Evidence-bound: what AgentDBA will and won’t link

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Forums

Four Rules for Adding AI Without Breaking What Already Works

SQL Server 2025 section missing?

A design question in a parent child relationship

Question of the Day

Hyperscale Replicas III