My Favorite SSMS Shortcut (After Copy/Paste)

• by Bert Wagner

• Bert Wagner

Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...

2017-11-28

193 reads

Does The Join Order of My Tables Matter?

• by Bert Wagner

• Bert Wagner

Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...

2017-11-21

230 reads

How to Search Stored Procedures and Ad-Hoc Queries

• by Bert Wagner

• Bert Wagner

Photo by Louis Blythe on UnsplashHave you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you...

2017-11-14

200 reads

4 Common Misconceptions About SQL Injection Attacks

• by Bert Wagner

• Bert Wagner

Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them?  Attend my online webcast on...

2017-11-07

234 reads

The Quickest Way To Get SQL Command Help

• by Bert Wagner

• Bert Wagner

Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...

2017-10-31

377 reads

10 Questions To Spark Conversation At Your Next SQL Event

• by Bert Wagner

• Bert Wagner

Photo by rawpixel.com on UnsplashHere’s a word for word transcription of a conversation I’ve had a hundred times over:
“Hi I’m Bert.  What do...

2017-10-24

163 reads

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

• by Bert Wagner

• Bert Wagner

Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance.  You take pride in knowing how to add indexes and...

2017-10-17

181 reads

How NOLOCK Will Block Your Queries

• by Bert Wagner

• Bert Wagner

Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...

2017-10-10

204 reads

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

• by Bert Wagner

• Bert Wagner

Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...

2017-10-03

136 reads

3 Things I Wish I Knew When I Started Using Entity Framework

• by Bert Wagner

• SQLServerCentral.com

• Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.75 (56)

Log in or register to rate

2017-09-29 (first published: 2016-05-17)

8,818 reads

• Discuss