Mike Scalise

I’m completely disgusted with @WyndhamRewards. I was just informed today that they sold the hotel where I have an upcoming reservation, abruptly canceled my reservation, and did absolutely nothing to make it right or accommodate—so now I need to scramble. Unacceptable…

@SQLMatt Matt, what does it look like for “Shortcuts for selected command” for “View.ObjectExplorerDetails” under Tools—>Options… ? F7?

Does anyone know how to restore lost functionality in a clean install of SSMS v19.1? Specifically, when I'm in a script and I hit Ctrl-N for a new script, SSMS brings up the New File dialog box, not a new script. Also, F7 does not open Object Explorer Details.

Function Friday: OPENJSON (T-SQL) - ift.tt/3rVqQfn #functionfriday #sqlserver #microsoft

Function Friday: RTRIM (T-SQL) - ift.tt/3zNN45J #functionfriday #sqlserver #microsoft

Function Friday: @@ROWCOUNT (T-SQL) - ift.tt/3ztrtPW #functionfriday #sqlserver #microsoft

Function Friday: TEXTVALID (T-SQL) - ift.tt/2TfYv6B #functionfriday #sqlserver #microsoft

Function Friday: @@FETCH_STATUS (T-SQL) - ift.tt/3wuBn1u #functionfriday #sqlserver #microsoft

Function Friday: SYSTEM_USER (T-SQL) - ift.tt/3AhdwG1 #functionfriday #sqlserver #microsoft

Function Friday: @@CONNECTIONS (T-SQL) - ift.tt/2UtzSU4 #functionfriday #sqlserver #microsoft

Function Friday: SUSER_NAME (T-SQL) - ift.tt/2S8FMJD #functionfriday #sqlserver #microsoft

Function Friday: LOWER (T-SQL) - ift.tt/3cxr45G #functionfriday #sqlserver #microsoft

Function Friday: STATS_DATE (T-SQL) - ift.tt/3piUaev #functionfriday #sqlserver #microsoft

Recently Posted: Updated First Responder Kit and Consultant Toolkit for June 2021 brentozar.com/archive/2021/0…

Function Friday: ISDATE (T-SQL) - ift.tt/3vvhyro #functionfriday #sqlserver #microsoft

Function Friday: FILEGROUP_NAME (T-SQL) - ift.tt/3vb0eYm #functionfriday #sqlserver #microsoft

Function Friday: @@TIMETICKS (T-SQL) - ift.tt/3hoq8nF #functionfriday #sqlserver #microsoft

Function Friday: @@LANGID (T-SQL) - ift.tt/3eqtKna #functionfriday #sqlserver #microsoft

@BrentO Don’t let perfect be the enemy of good. Write queries up to the point that they do what you want in an acceptable amount of time and using an acceptable amount of resources.

If you could give just one piece of advice about writing good queries, what would it be?

Function Friday: TODATETIMEOFFSET (T-SQL) - ift.tt/2QzOzDH #functionfriday #sqlserver #microsoft

Function Friday: CHECKSUM (T-SQL) - ift.tt/1KpLJ7L #functionfriday #sqlserver #microsoft