Tuesday, November 12, 2013

Setting CMD as the default

So I've tried setting CMD as the default program to run .cmd files in Windows 8.

Click Windows button, and then search for default and then choose Default Programs.

Inside of Default Programs, it is not possible to associate .cmd files with CMD. Isn't that maddening?

If I find a way to do this, then I'll set it up so .cmd files on my system run with Adminstrator authority. 

The idea is:
1. I'm developing on the machine, and need to change / manage / mangle various files and settings quickly through .cmd files.
2. I don't want to be prompted UAC every time I do (1), above.

So I'm thinking it's a default "security feature" that you can't rewire the association without a registry hack, but that's going to be my next step.

Tuesday, November 5, 2013

Windows Server 2012 and SQL 2012 Configuration Manager

From the techNet article:

To access SQL Server Configuration Manager Using Windows 8

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager not does not appear as an application when running Windows 8. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager11.msc 

But then, once you've found it, push enter to start it.

Then, go back, and search again. This time, it will show up on the left hand side of the search window, as a previously run app. Right click it, and choose "Pin To Start" so you don't have to hunt for the msc the next time.

Alternate Method

If you're more the "make my own" type, then you can :

Get to desktop mode in Windows 8.
Right click on the desktop.
Choose New >> Shortcut
As the location of the item, paste  SQLServerManager11.msc
Click OK.
Right click your new shortcut, and from the pop up menu, choose "Pin To Start".