Quick Command Shells–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This isn’t a SQL post, per se, but since I’ve been using lots of PowerShell for SQL stuff at times, this is a handy trick I picked up.

I was reading the announcement on the Windows Insider build 14971, which will have a few new things. One of these is the default command shell won’t be cmd.exe any longer. It will be PowerShell.

Buried in the announcement was a tip I’d never heard. I don’t have any real cmd additions to my Windows machines, so to get to a particular folder in a command shell, I usually do lots of “cd”s or I right click in the address bar, and copy the path. Thankfully Windows 10 lets me paste this easily into a command prompt.

2016-11-21 16_21_20-EndtoEndEncryptionwithSQL2016

There’s another way.

I can click the address bar and type “cmd”.

2016-11-21 16_21_47-EndtoEndEncryptionwithSQL2016

When I do this, I get a new command prompt at that location, as shown here. I do install ConEmu on my machines, so that’s where the prompt opens.

2016-11-21 16_21_55-cmd

That’s super handy.

We’ll see how may workflow changes when PoSh is the default shell, but I’m looking forward to it.


The quick tips that help me work more efficiently are what I’m writing in these posts. Here’s one that took my 5 minutes, and you can write this kind of post as well. Show off what you know, do, and have learned.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

1 Response to Quick Command Shells–#SQLNewBlogger

  1. rsterbal says:

    A handy reverse of this is when you are in the cmd shell to type:

    explorer .

    which opens explorer to the current directory in the cmd shell

    The open command window here on the explorer context menu is also a good way to navigate to a particular directory of a command prompt.

    Here are some ways of doing that from stackoverflow: http://stackoverflow.com/questions/378319/windows-explorer-command-prompt-here/379804


Comments are closed.