Skip to main content

What is SQL Server DB Queries?

SQL Server DB Queries
The standard for SQL Server management is to use SQL Server Management Studio (SSMS). It provides a host of options, but one of its main uses is to run queries against a database to perform inserts, updates, deletes, selects, and more. It works wonderfully, but it is a big application, one that you have to download and install nowadays, and it can take a couple of minutes to start and log into it.

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.

Gary Lucero


Popular posts from this blog

MaxLeafSoft Privacy Policy

MaxLeafSoft and its applications never store your personal data.

Comparison of Sync2Folders Pro to BASK

It wouldn't make sense to compare Sync2Folders Pro to Beyond Compare or other mature, well established programs with similar functionality. This is true for a number of reasons, including:
Sync2Folders Pro doesn't offer a way to compare file contents or to copy contents line-by-line from one file to another.Sync2Folders Pro isn't backed by a team that has programmers as skilled as those at Scooter Software and elsewhere. I am capable, but this isn't my main job, and as such, I'm not as good as they are!Sync2Folders Pro is free. There are other free utilities that are probably more robust, but that's not the point. The point is, I'm not going to compare this program to the competition because there is no competition here. I wrote Sync2Folders Pro for myself, and the only utilities I'll compare it to are those I also wrote. I could compare it to Sync2Folders Lite, but it surpasses that program handily. Sync2Folders Pro has an entirely new code base, and ha…