Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.

A better remote desktop manager

First off, if you are using RDC.... why? At least move up to RDCMan, a microsoft tool that allows for much quick context switching between machines, inherited password settings for a group of servers, and more.

Next, if you are using RDCMan... and perhaps you work with a lot of remote machines, perhaps there is an even better option? There are some great alternatives out there, and in my experience, with a little learning curve, the one I've worked on with Devolutions is fantastic!

Devolutions Remote Desktop Manager

Disclaimer: I have been provided with a free license because I mentioned I might review the product. This doesn't impact my assessment of the tool.

I'm a big fan of this app after having used it for months to get a feel for it. I've found it helpful when working with remote desktop machines, as well as some basic credential management. For folks dealing with lots of remote machines, I think this tool is well worth the investment and it has my stamp for one of my top essential tools in my cool-tools toolkit.

Having to deal with a lot of remote machines, especially ones that change IP addresses periodically can be annoying for a DBA trying to remotely connect again. Devolutions Remote Desktop Manager (RDM) has some really cool functionality that can help automate refreshing these lists from a variety of sources.

Synchronized Session Listing

You can setup a synchronized session listing based on csv, activedirectory, spiceworks, and more. Eventually, I believe they'll have an amazon ec2 synchronizer as well. In the meantime, with some powershell magic we can create a synchronized listing of remote machines to work with, no longer having to update ip's manually in a Amazon EC2 system.

Output Results from Powershell into CSV Source

setup a powershell script that would obtain EC2 instances and output into a csv file.

I found pieces of the needed code from various sources and modified to work for me. It's not elegant, and much better ways are available I'm sure. This was helpful to me though and got the job done!

Automatically keeping things up to date

Synchronizing automatically gives us the flexibility to have a scheduled script to run the powershell command to get a new list of machines, and have the synchronized list run automatically maintain the latest connection information. In my case, I setup the powershell script to run every X hours so my connection information was always up to date.

organized results

Thanks to the synchronizer, I know have two folders with separated instances for production and QA, allowing me to quickly access with minimal effort!

This would allow me to set credentials as well, to reduce the effort in logging in for each of the sets of instances

Other Cool Stuff

Multiple Monitor Support

Microsoft remote desktop connections have support for multiple monitors by spanning display. I tested this out with an unconventional setup. I have 3 24inch monitors, with 1 landscape in the middle surrounded by 2 in portrait mode. It had some problems with this as it's trying to create a spanned clone, however, if I had a typical setup, I think this would work fine, (such as a dual screen setup with the same orientation).

Continual Updates

I'm continually getting updates on this product. In any inquiries on their forum, I've seen helpful responses from staff within the day, with great support help (such as powershell tips on accomplishing what I needed with synchronizers)

Better Local Password Management

I'm a big fan of Lastpass, but as I use it for personal password management, I wanted to keep my work related passwords entirely separate. Devolutions RDM offers some nice password management options and credential inheritance setup.

Jump

If you have a scenario where you need to remote into one machine and then remote from that machine to another, things can get very confusing with copying/pasting/navigating. RDM solves this by having a "RDM Jump Agent", basically a service that allows you to set a remote desktop connection as a "jump point" and then connect through that connection to the next destination, while using one remote desktop window in the app. For those scenarios, I found it incredibly helpful. Best scenario... just avoid having to jump in the first place :-)

Can wrap up the trick of running SSMS (Sql Management Studio) with "RunAs" as a different domain and user, allowing locally run SSMS to be connected to AWS, or other environments.

Other Odds and Ends

Lots of features, so I'm just covering some of the highlights that are of interest to me.

Quickly ping and get status

View event logs from remote machine loaded in your local event viewer

List services

Run powershell script remotely with RDM-Agent (executes the script as if running locally, and could do this in parallel with other instances)

Summary

I review quite a few apps, but this one is really difficult to review in detail as it covers such a range of functionality I've never even touched. The only con to the app I'd say is it can have a bit of a higher learning curve than using the plain old Remote Desktop Manager from windows due to the breadth of functionality it covers. However, once using this app, and discovering little pieces of functionality here and there, this is in my permanent "essential tools" toolkit.

Free version

They have a free version that will suffice for many people. The pro version has more enterprise level focus, so give the free one a shot if you are looking for a basic improvement to your RDM workflow

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.