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

112 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,004 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

13 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

446 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

16 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,173 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,713 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

392 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

11 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

Measuring RAG Solutions: Are We Retrieving the Right Information?

Advice I Like: Lots of Ideas

Building a DBA Agent for Your SQL Server Estate with MCP

Forums

How do I connect to a SQL Server database on my ISP?

Looking for New Blood

Server-Level Row Counts for Tables and Views

Question of the Day

Hyperscale Replicas I