sql

PASS Summit On Tour NYC

This week for the first time since 2019 I attended a PASS Data Community event in person. Last year RedGate announced that in addition to the PASS Summit in Seattle there would some satellite events in New York City, Dallas, and the Netherlands. My employer has a budget for training events, and since we are on the east coast now, I decided to attend the PASS Summit on Tour in New York City. I may try and write up some reviews of the sessions I attended, but this post isn’t about that.

Continue reading →

Select ALL THE THINGZ!

There are some T-SQL best practices that I have been hearing about for so long that it surprises me when I run into people who don’t know about them. Then I remember “every single person in the world starts out with absolutely zero knowledge about SQL Server“. With that in mind I have decided to document some of the things I have been seeing a lot of recently. I have been working on a project refactoring T-SQL for the past several months and one of the patterns I replace without thinking about it is

SELECT *

Continue reading →