A Better Way To Script Database Objects

• by Bert Wagner

• Bert Wagner

Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...

2018-01-09 (first published: 2018-01-02)

3,288 reads

I Have A SQL Login – Why Can’t I Connect?

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday prompt created by Arun Sirpal.  Adam Machanic created T-SQL Tuesday...

2018-01-09

383 reads

SQL and NOT SQL: Best of 2017

• by Bert Wagner

• Bert Wagner

Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...

2017-12-26

414 reads

How To Create Multi-Object JSON Arrays in SQL Server

• by Bert Wagner

• Bert Wagner

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...

2017-12-19

1,614 reads

Learning Through Blogging and Speaking

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...

2017-12-12

157 reads

Reducing the Number of Reads in Your Queries

• by Bert Wagner

• Bert Wagner

“A-Bridged” – reducing reads – get it?  I’m sorry you’re reading this.  Photo by Jamie Street on UnsplashIn last week’s post, we went over how...

2017-12-12

202 reads

How to use Statistics IO to Improve Your Query Performance

• by Bert Wagner

• Bert Wagner

SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...

2017-12-05

273 reads

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

194 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

234 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

206 reads