SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Archives: January 2018

The Fastest Way To Locate Errors In Your SQL Query

Photo by N. on Unsplash

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 error messages that point me to the precise location of the error in my code: Read more

1 comments, 1,679 reads

Posted in Bert Wagner on 30 January 2018

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

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

Today we’ll examine what to do when our geographical polygon is showing us inverted results.

Watch this… Read more

0 comments, 366 reads

Posted in Bert Wagner on 23 January 2018

Importing GeoJSON Earthquake Data Into SQL Server

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 events like earthquakes.

This week I want to take a look at how you can import this earthquake data, encoded… Read more

0 comments, 557 reads

Posted in Bert Wagner on 16 January 2018

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

This post is a response to this month’s T-SQL Tuesday prompt created by Arun SirpalAdam Machanic created T-SQL Tuesday as a way for SQL users to share ideas about interesting topics. This month’s topic is “Your Technical Challenges Conquered”.

DBA Skills 101: SQL Logins

While writing last… Read more

0 comments, 380 reads

Posted in Bert Wagner on 9 January 2018

A Better Way To Script Database Objects

Photo by Andy Beales on Unsplash

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 much better way to generate database object change scripts.

Prefer video?  Watch this week’s… Read more

8 comments, 3,276 reads

Posted in Bert Wagner on 2 January 2018