I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).

First I'll walk through how to create a batch file for anyone unfamiliar with the handy Windows scripts, and then explain how to use some simple commands to start or stop resource-draining ...