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.

Blog Post

Trailing Spaces in SQL Server

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

2019-07-03 (first published: )

1,043 reads

Blog Post

Joker’s Wild

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-25 (first published: )

452 reads

Blog Post

Multiple Identity Inserts

Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...

2019-06-25

9 reads

Blog Post

Multiple Identity Inserts

Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...

2019-06-25

16 reads

Blog Post

Joker's Wild

This past weekend I had a blast presenting Joker's Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter).

Watch this week's video on YouTube
Table of contents:

What is...

2019-06-11

9 reads

Blogs

Understanding Fabric Ontology

By

What problem is Fabric Ontology trying to solve? For years, most data conversations have...

QUOTENAME Basics: #SQLNewBlogger

By

Recently I ran across some code that used a lot of QUOTENAME() calls. A...

When growing companies outgrow Excel

By

There are some telltale signs that your growing business has outgrown Excel for your...

Read the latest Blogs

Forums

BCA KCP Demak | Tlp/Wa:0818751777

By Layanan.24jam

Tlp/Wa_Cs:0818-751-777  Jl. Sunan Kalijaga No.03 & 04, RT.04/RW.10, Tanubayan, Bintoro, Kec. Demak, Kabupaten Demak,...

BCA KCP Dinoyo | Tlp/Wa:0818751777

By Layanan.Bank.BCA

Tlp/Wa_Cs:0818-751-777  Jl. Mayjen Haryono No.160, Dinoyo, Kec. Lowokwaru, Kota Malang, Jawa Timur 65114

Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployment...

Visit the forum

Question of the Day

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

See possible answers