Four SQL Server Syntax Rules I Always Follow
July 11, 2019 | 0
Aaron Bertrand explains four conventions he always follows when writing T-SQL queries.
A subtle redirection
Aaron Bertrand explains four conventions he always follows when writing T-SQL queries.
See how you can use new functions like DATEFROMPARTS to simplify otherwise really cryptic methods to obtain key dates (like the first day of the current month).
Get a first-hand look at some of the ways NOLOCK can produce incorrect data.
Learning Pathways are a new, innovative way to take advantage of the sessions offered at PASS Summit.
Aaron Bertrand shares his slides and demos from his presentations at SQLDay in Wrocław, Poland.
Aaron Bertrand talks about a few of the things that he wished he had learned earlier on.
Aaron Bertrand announces that he is among the handful of community members in the inaugural group of official bloggers at PASS Summit 2019.
This tip shows how powerful the CASE expression is, and some of the nuances in its behavior.
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
See one approach to collecting extended properties information across all of the databases on a server.
Break free from the limitations of history retention and take control at the job or even step level.
See what improvements were made in SentryOne Plan Explorer 19.0.2.