What is SQL Server DB Queries?
|SQL Server DB Queries|
But managing queries in SSMS is a hassle, and I often perform the same sorts of queries on a daily basis. One option is to create a text file with all of the queries and then load that in SSMS and select the query you want, run it, just keep SSMS running with that file loaded and use it as needed. But if you need to run it on one virtual machine, then another; it becomes a big pain. And maintaining a bunch of files of queries is even more of a pain.
Which is why I created SQL Server DB Queries. It's a lightweight SQL query tool that doesn't offer Intellisense, and doesn't provide any tools beyond a text box for your query, a status line for number of rows returned, and a grid of results. And that's it, beyond the ability to save the queries to a single XML file, and then quickly load, edit, and execute them.
It does have some limitations. You connect it to a single server, using either a username and password or Windows authentication, unlike SSMS which can connect to multiple servers, allowing management of SQL Server across an enterprise. It stores passwords in plain text in the app config file, which I know is a big no-no, which is why I recommend Windows authentication.
So SQL Server DB Queries is limited, but it's also useful. It's lightweight, it provides a quick and easy way to maintain a list of queries, and it works.