Category: Windows Tips
-
How to Run SQL Server Management Studio as a Different Windows User
If you’re using Windows Authentication for your SQL Server database you’ll need to run SQL Server Management Studio (SSMS) as that Windows account to test queries. SSMS normally runs as the user logged in to Windows, but there is a simple way to run it as the database access account. Just shift-right-click on a shortcut…
-
Open a CMD Window From Anywhere!
In Windows 7, hold down shift and right click a folder to see some additional menu items. You’ll notice a few extra options like “Open command window here” and “Copy as path”. Open command window here Often when browsing folders in Windows Explorer you will want to open a command shell, using the directory being…
-
Command Line Display of a Folder Tree
If you have ever needed to print out a folder hierarchy in Windows this is for you. Go to the command line, traverse to the folder you want to list out and type TREE.
-
Merge Worksheets in Excel
Sometimes you have a couple Microsoft Excel worksheets that you need to combine based on a column. This article will show you how to use VLOOKUP to merge sheets based on a specific ID that is available in both.