(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
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the… Read More »Introducing Azure Data Studio
[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
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server, was decoupled from the server… Read More »SQL Server Management Studio v17.0