Bert Wagner

This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...

2018-10-11 (first published: 2018-10-02)

3,002 reads

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...

2018-10-02

6 reads

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...

2018-10-02

15 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...

2018-10-03 (first published: 2018-09-25)

1,743 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
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...

2018-09-25

11 reads

Shortchanged with International Money in SQL Server

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
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...

2018-09-25

11 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

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

2018-09-18

1,611 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
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:...

2018-09-18

12 reads

Extracting JSON Values Longer Than 4000 Characters

by Bert Wagner

Bert Wagner

Watch this week's video on YouTube
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:...

2018-09-18

9 reads

Faking Temporal Tables with Triggers

by Bert Wagner

Bert Wagner

This post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way...

2018-09-26 (first published: 2018-09-11)

2,509 reads

Bert Wagner

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Shortchanged with International Money in SQL Server

Shortchanged with International Money in SQL Server

Shortchanged with International Money in SQL Server

Extracting JSON Values Longer Than 4000 Characters

Extracting JSON Values Longer Than 4000 Characters

Extracting JSON Values Longer Than 4000 Characters

Faking Temporal Tables with Triggers

Blogs

A New Word: Dorgone

Tell It Once: Setting Up Claude With Skills and MCP Servers

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

Forums

does anyone used https://github.com/ktaranov/sqlserver-kit

How Can Database Performance Improve the Overall Website Experience?

When And How to Automate?

Question of the Day

Hyperscale Replicas II