.NET Tips and Tricks

Blog archive

Free Tool: Try Out SQL Queries and Explore Databases with QueryExpress

As an independent consultant, I move from one client's computer to another. Because of that, I frequently find myself on computers where I need to browse a database but don't have a copy of SQL Server Management Studio installed. If you want a quick replacement for Management Studio, try QueryExpress. It's so small and downloads so quickly that you'll think it hasn't download at all. QueryExpress also requires no installation: just drop it on your desktop and double-click its icon to run it.

QueryExpress isn't a complete replacement for Management Studio by any means, but it gives me everything I need: a text window for entering SQL statements, a TreeView of all of the databases on the server (with their tables, stored procedures, and functions) and a GridView of any query results.

There's some stuff missing that I wish was there: QueryExpress won't scan for databases for you to connect to, so I have to know what my server and database engine names are; and the undo in the text window only goes back one step. But, to compensate for that, QueryExpress works with SQL Server, Oracle or any OLE DB compatible database.

If you want something more powerful that's still free, you can take a little longer and install Query ExPlus, which builds on Query Express.

Posted by Peter Vogel on 04/15/2013 at 1:16 PM


comments powered by Disqus

Featured

  • Xamarin.Forms 5 Preview Ships Ahead of .NET 6 Transition to MAUI

    Microsoft shipped a pre-release version of Xamarin.Forms 5 ahead of a planned transition to MAUI, which will take over beginning with the release of .NET 6 in November 2021.

  • ML.NET Improves Object Detection

    Microsoft improved the object detection capabilities of its ML.NET machine learning framework for .NET developers, adding the ability to train custom models with Model Builder in Visual Studio.

  • More Improvements for VS Code's New Python Language Server

    Microsoft announced more improvements for the new Python language server for Visual Studio Code, Pylance, specializing in rich type information.

  • Death of the Dev Machine?

    Here's a takeaway from this week's Ignite 2020 event: An advanced Azure cloud portends the death of the traditional, high-powered dev machine packed with computing, memory and storage components.

  • COVID-19 Is Ignite 2020's Elephant in the Room: 'Frankly, It Sucks'

    As in all things of our new reality, there was no escaping the drastic changes in routine caused by the COVID-19 pandemic during Microsoft's big Ignite 2020 developer/IT pro conference, this week shifted to an online-only event after drawing tens of thousands of in-person attendees in years past.

Upcoming Events