Open in app
Sign inGet started
Latest

Shutting down my publication

I’ll be shutting down my Medium publication at https://blog.bertwagner.com sometime during the next week. All URLs will be redirected to my…
Go to the profile of Bert Wagner
Bert Wagner
Why Is My VARCHAR(MAX) Variable Getting Truncated?

Why Is My VARCHAR(MAX) Variable Getting Truncated?

Watch this week’s episode on YouTube.
Go to the profile of Bert Wagner
Bert Wagner
Is It Possible To Conditionally Index JSON Data?

Is It Possible To Conditionally Index JSON Data?

Check out this week’s episode on YouTube.
Go to the profile of Bert Wagner
Bert Wagner
3 Essential Tools For The SQL Server Developer

3 Essential Tools For The SQL Server Developer

This post is a response to this month’s T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to…
Go to the profile of Bert Wagner
Bert Wagner

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

Watch this week’s episode on YouTube.
Go to the profile of Bert Wagner
Bert Wagner
AT TIME ZONE: The easy way to deal with time zones and daylight savings time

AT TIME ZONE: The easy way to deal with time zones and daylight savings time

Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers and school…
Go to the profile of Bert Wagner
Bert Wagner
How To Steal Data Using Second Order SQL Injection Attacks

How To Steal Data Using Second Order SQL Injection Attacks

One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter directly into…
Go to the profile of Bert Wagner
Bert Wagner

Full Automatic Tuning: SQL Server 2026’s Most Killer Feature

This post is a response to this month’s T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. T-SQL Tuesday is…
Go to the profile of Bert Wagner
Bert Wagner
2.5 Ways Your ORM Is Vulnerable To SQL Injection

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Go to the profile of Bert Wagner
Bert Wagner
Splitting It Up: Side by Side Queries In SSMS

Splitting It Up: Side by Side Queries In SSMS

There are times when you are writing a query while referencing another piece of information: the results of another query, a variable…
Go to the profile of Bert Wagner
Bert Wagner
About SQL Lessons with Bert WagnerLatest StoriesArchiveAbout MediumTermsPrivacyTeams