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). If this was easy ...

Everything I'm running across is either full gui (which is cool, but overkill) or too complex for his liking (MS's own server performance advisor) and I'm just not enough of a programmer to create ...

Before we can backup the database you need to create SQL Stored Procedures under Databases > System Databases > master > Programmability. Right-click it and click New Stored Procedure. In the SQLQuery ...

Save that batch script with a .bat extension, ... Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.