I'm going to show you how to use SQL Server Management Studio to get data from Configuration Manager. I want to thank Adam Cook and Adam Gross who both gave me the encouragement to finally put this together. For best SQL readability, make sure you're watching in HD.

The following 60-second video is the one I demoed at MMS Jazz 2019 to show how to quickly edit a Microsoft Doc without needing to understand Git command line tools or using VSCode.

In this video demo I'm going to show you how use VLOOKUP on a table in Excel. In order to see the text clearly, please set the video to one of the two HD options using the gear icon. Attachment: Using the VLOOKUP Function

In this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …