-->
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: October 2017

The Quickest Way To Get SQL Command Help

Formula One …. F1 …. Photo by Jp Valery on Unsplash

Every once in a while I discover a SQL Server Management Studio trick that’s apparently been around forever but is completely new to me.

Today I want to point out one of those features that had me thinking “how… Read more

0 comments, 136 reads

Posted in Bert Wagner on 31 October 2017

10 Questions To Spark Conversation At Your Next SQL Event

Photo by rawpixel.com on Unsplash

Here’s a word for word transcription of a conversation I’ve had a hundred times over:

“Hi I’m Bert.  What do you do?”

“I’m ____ and I’m a SQL developer.”

“That’s cool, me too.”

*crickets*

*I look down at phone because I don’t know what to…

Read more

2 comments, 69 reads

Posted in Bert Wagner on 24 October 2017

How to Make SQL Server Act Like A Human By Using WAITFOR

Photo by Fischer Twins on Unsplash

You probably tune your queries for maximum performance.  You take pride in knowing how to add indexes and refactor code in order to squeeze out every last drop your server’s performance potential.  Speed is usually king.

That’s why you probably don’t use SQL Server’s… Read more

0 comments, 78 reads

Posted in Bert Wagner on 17 October 2017

How NOLOCK Will Block Your Queries

Photo by James Sutton on Unsplash

Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints.  The fact that it applies to NOLOCK queries was a huge surprise to me though, hence the title.

Lots of people don’t like NOLOCK (i.e. the read… Read more

1 comments, 78 reads

Posted in Bert Wagner on 10 October 2017

3 Tips You Need To Know When Using PowerShell with SQL Server

Watch this week’s interview with Drew on YouTube.

Have you ever had to perform repetitive tasks in SQL Server?

Maybe you’ve had to manually verify backups, script out all of a server’s logins/groups/permissions, or refresh a dev environment with data.  With PowerShell, you can automate all of these manual… Read more

0 comments, 59 reads

Posted in Bert Wagner on 3 October 2017