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.

Recursively Querying Row Groups

Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....

2020-09-02 (first published: )

521 reads

Moving 1/3 of a heap

Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...

2020-08-03 (first published: )

262 reads

Blogs

Azure Databricks to Power BI

By

A very common approach is to query data straight from Databricks via Power BI....

SQLSaturday #1000! Join Oregon Virtually this Saturday

By

Honored to be a part of not just SQLSaturday #1000, but the long proud...

Azure DevOps–Reconfiguring an Agent

By

This post looks at how to re-configure a local Azure DevOps agent when you...

Read the latest Blogs

Forums

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct forum to post my question. I...

SQL Case statement

By mtz676

select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers