SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Small Management


Small Management

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61393 Visits: 19097
Comments posted to this topic are about the item Small Management

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Your Name Here
Your Name Here
SSC Veteran
SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)

Group: General Forum Members
Points: 256 Visits: 811
I'm 95% certain I would use a phone/PDA to administer my servers. More often than not the "after hours crisis" isn't something that would force me to bang out code with my thumbs on a "Barbie Dream Keyboard" <lol> that just came to me... but it would depend on whether it would be used to connect to a remote console or to run a SSMS-type app. I've VNC-ed into a console where the PDA only showed a portion of the screen and I had to scroll around to see other parts of the console. That was a pain in the butt. I'd probably use an app that has some access to a code library like SMSS's template explorer and execute something I'd written to handle the situation.

Maybe something iPad or Android tablet sized would work but then if you're going that far you might as well carry a laptop or notebook.
Mike Caputo
Mike Caputo
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 13
My initial reaction is to say I can't imagine a way to avoid the frustration you mentioned. You might be able to hard-code a bunch of specific scenarios of commands to try to fix an issue, but then it would just be like a "troubleshooting dashboard" - not really managing the environment. I mean, think about how easy it is to fat-finger something on a touch screen. Maybe I'm just too clumsy, but I wouldn't want to take that chance on a production server.
TravisDBA
TravisDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1946 Visits: 3069
Managing all my myriad of SQL Servers from a handheld? That would be like trying to cut down an oak tree with a Swiss Army Knife. I guess sooner or later you could do it, but it would be a very long and painful process No thanks.:-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
David Benoit
David Benoit
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3318 Visits: 3650
I can't say that I would use it for extensive work but if I needed to deal with an alert quickly or run a quick query I might use one. Certainly willing to test for anyone working on the technology. :-P

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
bronder
bronder
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 22
I do troubleshoot using an ipad. It's a lot easier than carrying a notebook or netbook. Usually I get an automated or manual alert via email about something (user locked out, NAS running out of space, hung TS session, failed file copy, db restore,etc). Urgent stuff usually has a workaround that can be easily implemented while the permanent fix can be done.

Ipad in had I establish a vpn and then RDP into the offending server, open the tool I need to use and then tap a few clicks or type a few things and the problem gets "managed".

Then when I get to my actual computer I can finish off the work, but in the meantime the users have continued being productive and I have been able to enjoy my meal, time off, movie, family time,etc while spending only a few minutes relieving the urgency of the situation.

I have used this for years now and users and management generally don't even know if i'm on duty or not. drawback is that they usually expect an inmediate answer, benefit is that I manage my off-on time at my convenience without sacrificing service.
IceDread
IceDread
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 1145
I don't do it today and frankly I dont think I want to do it. Because if I'm not at work I prefer not to work and I don't want to carry around something just to be available for work while I'm not working. However, for trips and such I believe it can be handy as techniques evolves, screens get better and so.
steve_frederick
steve_frederick
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 244
I've used the first two smart phone apps in a pinch:

1) PocketCloud -- which allows me to remote into any of my servers. Obviously, the screen size and keyboard are not ideal, but it can be done. There are Mac or Windows desktop with your iPad, iPhone or iPod Touch versions. (See: http://itunes.apple.com/us/app/pocketcloud-remote-desktop/id326512817?mt=8 )

2) SQL Wrenches -- which allows me to execute stored procedures & views on any server. It can be used to monitor disk space, backups, etc., anything you can do with a view or stored procedure. However, I have noticed that the more joins in my logic, the more likely the app is to time out before it returns results, even if the result set is small. This app has potential, but it's not quite there yet.
(See: http://itunes.apple.com/us/app/sql-wrenches/id426888582?mt=8 )

3) SQL Guages -- which provides various PerfMon like measurements. (See: http://itunes.apple.com/us/app/sql-gauges/id404189907?mt=8 )
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search