Product Reviews

PocketDBA 2.0

Handy DBA tool for handhelds.

PocketDBA is, as you might guess, a database administration tool for handheld platforms (either Palm or PocketPC). Depending on what you configure and install, it can support SQL Server, Oracle, or DB2. Expand Beyond installs its own Application Server on your network. The cliences communicate wirelessly, with SSL encryption and optional RSA SecurID protection, with the Application Server. The Application Server in turn talks to the databases. The Application Server itself runs on Solaris 8, Windows NT or 2000, or Red Hat Linux 7.2 or 7.3.

After you've installed the Application Server, the next step is to tell it which databases it's going to manage; it does not just let you prowl through the whole network. Once that's done, handheld devices simply connect to a specified URL to use the databases.

From the handheld, you can perform a variety of DBA tasks:

  • View connected users
  • Manage users
  • View blocks
  • Change permissions
  • Rebuild indexes
  • Execute arbitrary SQL statements

That's just a sampling. With the proper permissions, you can even start and stop the SQL Server itself and perform some on-the-fly tuning. The Expand Beyond interface is seriously stripped down to fit on the small screen, of course, but it makes good use of tabbed dialogs in the limited space to display information, and keeps the number of mouse clicks to a minimum.

If you're a DBA who's tethered to his computers, you might look at Expand Beyond as a way to break free.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • Google Goes Live with Managed Service for Microsoft Active Directory

    Google's Managed Service for Microsoft Active Directory is now a "generally available" service, according to a Thursday Google announcement.

  • Dell Sells RSA Assets for $2 Billion

    Dell's RSA security solutions businesses, including the RSA Conference, were bought by a consortium of companies for about $2 billion, according to Tuesday announcements.

  • How To Get Started as a Windows Insider

    Microsoft's Windows Insider program is invaluable for IT pros who want to test drive new Windows 10 features before the update rolls out to their entire organization. If you haven't already signed up to be an Insider, here's how to do it.

  • Old Fashioned Mics

    Microsoft Preps for RSA Conference with Multiple Security Product Announcements

    Microsoft announced various enterprise security solution product milestones this week in advance of the forthcoming RSA Conference, which will start on Feb. 24.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.