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: July 2018

Should You Use Index Hints?

Watch this week’s post on YouTube

One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.

Usually it does a pretty good job, which is a great because if it didn’t then we’d be spending most of our… Read more

3 comments, 3,159 reads

Posted in Bert Wagner on 31 July 2018

Pinal Dave Helps Me Fix My Performance Tuning Problems

Be sure to check out this week’s video on YouTube.

This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself.  Pinal is creative, hilarious, and kind; making this video with him was A BLAST!

Although the video is a little tongue… Read more

4 comments, 295 reads

Posted in Bert Wagner on 24 July 2018

T-SQL Tuesday #104 Roundup

This month’s T-SQL Tuesday topic asked “What code would you hate to live without?” Turns out you like using script and code to automate boring, repetitive, and error-prone tasks.

Thank you to everyone who participated; I was nervous that July holidays and summer vacations would stunt turnout, however we wound… Read more

5 comments, 2,621 reads

Posted in Bert Wagner on 17 July 2018

Building Dynamic Table-Driven Queries

This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database and professional topics every month.

This month’s topic is asking what code would you hate to live without?

When given… Read more

1 comments, 3,040 reads

Posted in Bert Wagner on 10 July 2018

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today’s online code community.

Before modern online programming communities, finding good code samples or sharing your own code was challenging.  Forums and email lists (if searchable) were good, but… Read more

42 comments, 257 reads

Posted in Bert Wagner on 3 July 2018