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

COUNT, DISTINCT, and NULLs

Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...

2019-03-05 (first published: )

3,577 reads

Blog Post

Why make?

This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard.  T-SQL Tuesday is a way...

2019-03-01 (first published: )

3,227 reads

Blog Post

Searching Complex JSON Data

Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...

2019-02-26

10 reads

Blog Post

Searching Complex JSON Data

Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...

2019-02-26

19 reads

Blogs

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Daan Mogot Telp:08218154374

By layanan_Bca88

Hub Via Wa:628218154374 Alamat: Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan,...

Alamat Kantor BCA KCU Kuningan Telp:08218154374

By m4rt1n4

Hub Via Wa:628218154374 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Jl....

Alamat Kantor BCA KCU Puri Indah Telp:08218154374

By R4nt4u

Hub Via Wa:628218154374 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers