(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve… Read More »T-SQL Tuesday Retrospective #011: Misconceptions
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data… Read More »These are the extensions I have installed on Azure Data Studio
A short post this week, to let you know that I’ll be presenting a brand new session to the Edmonton PASS user group (EDMPASS) next… Read More »Speaking at the Edmonton PASS user group on 16 July 2020
TL;DR: No. A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the… Read More »Is it true that editing a single row in Management Studio empties and reloads the entire table?
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even… Read More »T-SQL aside: replace PRINT with RAISERROR
[2018-07-03 edit: The original name of this feature was XE Profiler, but it was changed to XEvent Profiler in SSMS 17.4.] I have a favourite… Read More »Gimmicks that work: XEvent Profiler in SQL Server Management Studio