-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

Archives: May 2018

Why Is My VARCHAR(MAX) Variable Getting Truncated?

Watch this week’s episode on YouTube.

Sometimes SQL Server doesn’t do what you tell it to do.

Normally that’s ok – SQL is a declarative language after all, so we’re supposed to tell it what we want it to do, not how we want it done.

And while that’s… Read more

0 comments, 214 reads

Posted in Bert Wagner on 15 May 2018

Contributing to Community

This post is a response to this month’s T-SQL Tuesday #102 prompt by Riley Major. T-SQL Tuesday is a way for SQL Server users to share ideas about different database and professional topics every month.

The prompt I’ve chosen to write about this month is how and why I… Read more

0 comments, 443 reads

Posted in Bert Wagner on 8 May 2018

Is It Possible To Conditionally Index JSON Data?

Check out this week’s episode on YouTube.

Recently I received a great question from an attendee to one of my sessions on JSON (what’s up Nam!):

At first glance it sounds like a filtered index question, and ultimately it is, but because of some of the intricacies involved in… Read more

0 comments, 1,651 reads

Posted in Bert Wagner on 1 May 2018