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

  • What Does Office 365 Support for New Surface Hardware Actually Mean?

    Microsoft has spilled a lot of ink touting the ways that its new Surface-branded peripherals will be bring Office 365 features to life.

  • Azure Active Directory ID Protection 'Refresh' Now Available

    Microsoft's enhancements to the Azure Active Directory Identity Protection service are now said to be "generally available" (GA), or ready for commercial use, per a Wednesday announcement.

  • Microsoft Releases Windows 10 Version 1909

    Microsoft on Tuesday announced the release of Windows 10 version 1909, a new operating system product that's also known as the "Windows 10 November 2019 Update."

  • November Microsoft Security Bundle Addresses 75 Vulnerabilities

    Of that number, 13 vulnerabilities are rated "Critical" to patch, while 62 vulnerabilities are deemed "Important."

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.