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

Blog Post

SELECT Expression Execution Order

Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...

2019-07-23 (first published: )

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

2019-07-10 (first published: )

481 reads

All authors

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