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

110 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,985 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

9 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

443 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

12 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

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...

2018-01-16

1,159 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,702 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

389 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

8 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

Think Twice Before Enabling Fabric’s Inbound Network Protection

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

Advice I Like: Responsibility

Forums

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

SQL Agent Job Automated Change Capture Process

Question of the Day

Finding a Database Master Key