THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Keep Your Server Clean by Using Virtual Applications

It's pretty well understood that it's highly desirable to keep servers lean and mean. But what do you do when you need to use a tool, particularly if it is needed only once? You could install the utility application and then remove it, but that does introduce risk. Virtual applications provide the answer. You can actually run an application without installing it.

There are two basic classes of virtual applications: agentless and those that require an agent. Microsoft Application Virtualization (formerly SoftGrid) and Altiris Software Virtualization Solution are well known examples of application virtualization that use an agent. In order for the virtualized applications to work, an agent must be installed on the machine. The agent provides a boundary, a sandbox, in which the application runs without interfering with what's installed on the machine. Agentless virtualized application solutions create a single, self-contained executable that runs without being installed and without elevated permissions. The application is isolated from the host it is running on and doesn't interfere. Examples of agentless virtualized application products are Xenocode and VMware's Thinstall. Trigence offers agentless application virtualization, but they haven't made it possible for me to evaluate it.

For a database server, the objective is to change it as little as possible. That's why I prefer agentless solutions. A large assortment of agentless virtualized applications can be downloaded from Another agentless solution worthy of consideration is Portable Apps. While technically not fully virtualized applications, the applications that are included with or can be added to Portable Apps run without being installed. This makes the Portable Apps suite a quite useful suite of tools for servers. I copied the Portable Apps suite to a Corsair high speed USB memory stick. You can use any USB memory stick, but I did notice a considerable performance improvement for high speed sticks compared to tradeshow freebies. Last week I needed to compute a MD5 hash for a SQL Server installation iso file. I inserted the USB stick and ran winMd5Sum without installing it or in any way messing up the server.

 Virtualized applications are also great for application testing, but that's a story for another day.

Published Wednesday, January 30, 2008 10:37 PM by John Paul Cook
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse currently studying to be a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement