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: September 2018

Shortchanged with International Money in SQL Server

Imagine you have to perform some salary analysis for your employer International Mega Corp.

The data you have to work with looks something like this:

DROP TABLE IF EXISTS ##InternationalMegaCorpSalaries;
CREATE TABLE ##InternationalMegaCorpSalaries
	EmployeeId int IDENTITY,
	Salary nvarchar(10),
	Country nvarchar(20),
INSERT INTO ##InternationalMegaCorpSalaries VALUES ('1,000.00','United States');

Read more

1 comments, 1,691 reads

Posted in Bert Wagner on 25 September 2018

Extracting JSON Values Longer Than 4000 Characters

A while back I built an automated process that parses JSON strings into a relational format.

Up until recently this process had been working great: my output table had all of the data I was expecting, neatly parsed into the correct rows and columns.

Last week I noticed an error… Read more

6 comments, 241 reads

Posted in Bert Wagner on 18 September 2018

Faking Temporal Tables with Triggers

This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional topics every month.

This month’s topic asks to share our experiences with triggers in SQL Server. Read more

9 comments, 2,398 reads

Posted in Bert Wagner on 11 September 2018

Does The Order Of Index Columns Matter?

When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.

Creating your first few indexes can be intimidating though, particularly when trying to understand what order to put your key columns in.

Today we’ll look at how row… Read more

2 comments, 4,258 reads

Posted in Bert Wagner on 4 September 2018