THE SQL Server Blog Spot on the Web

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

John Paul Cook

DBA Toolkit on a USB Stick

Wouldn't it be great to have all of your DBA tools on a USB stick and have them just work without installing anything or copying any files? Is is at least partially possible! You know the problem: You visit a client and you aren't allowed to install anything on their computers or connect your laptop to their network. Just for research purposes, I decided to see if agentless application virtualization could help. I downloaded a trial version of Thinstall and virtualized SQL Server Management Studio, SQL Profiler, and the rest of the tools that come with a full client-only installation of SQL Server 2005.

The entire suite of virtualized SQL Server 2005 client tools was about 660 MB. SSMS and the Database Engine Tuning Advisor worked. BOL and SQL Profiler did not. Because I can't use the virtualized applications after the Thinstall evaluation period, I didn't do any troubleshooting or tweaking of the apps that didn't run. This was just a proof of concept exercise.

Licensing of virtual applications might be a bigger challenge than the technical ones. From a licensing compliance perspective, the ideal applications to virtualize are those which are licensed per person. You would buy the tools you need, virtualize them, and take them with you wherever you'd go. I wonder if there is a marketing opportunity for software vendors. They could buy the virtualization software and provide a virtualized copy of their application. I'd like to buy applications that just work, no installation needed. Installing applications is so last millenium! It's not always feasible to virtualize an application, but when it works, it can be very useful.

Published Sunday, February 03, 2008 10:47 AM by John Paul Cook

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

Comments

 

andyleonard said:

Hi John,

  This is a great idea - especially for consultants.

:{> Andy

February 3, 2008 11:56 AM
 

Uri Dimant said:

Hi John

It looks very promising. I'll be checking it soon. However, I recently visited one of out clients (pretty big company) which does not allow (locked down) to use USB at their office :-)))

February 4, 2008 12:05 AM
 

joewebb0 said:

Very cool. I wonder if any of the SQL tools manufacturers would find this a viable market, similar to the mobile apps for administering SQL Server? Probably not a sizeable enough market, though.

Joe

February 6, 2008 8:26 AM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is both a Registered Nurse and a Microsoft SQL Server MVP experienced in Microsoft 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. Experienced in systems integration and workflow analysis, John is passionate about combining his IT experience with his nursing background to solve difficult problems in healthcare. He sees opportunities in using business intelligence and Big Data to satisfy healthcare meaningful use requirements and improve patient outcomes. John graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement