SQLServerCentral / Editorials / SQLServerCentral.com / How Do You Work When You are Not at Work? / Latest Posts

RE: How Do You Work When You are Not at Work?

Bob Vipond — Thu, 03 Feb 2011 08:44:46 GMT

Fortunately I haven't had to respond after hours to a SQL emergency. I have email messages sent when SQL Agent jobs go wrong. Its nice that I don't have to carry a pager or work phone anymore!If I do need to work after hours I can login from home using a VPN connection to my computer back at work. I can then operate as if I were at my desk.

RE: How Do You Work When You are Not at Work?

SQLRNNR — Mon, 13 Dec 2010 15:28:24 GMT

[quote]when you are away from work and a database-related problem occurs, how are you generally notified? [/quote]First notification is via email. Then it progresses to phone calls if the email is not noticed.[quote]Secondly, once you’ve been alerted, how do you generally connect to your servers to see what is going on? Do you use a smartphone, a tablet computer, a netbook/laptop/desktop computer?[/quote]I connect via VPN from laptop.[quote]And third, how often can you typically resolve the problem remotely, and how often do you still have to come into the office to fix things?[/quote]90% of the time it can be fixed remotely.

RE: How Do You Work When You are Not at Work?

bradmcgehee@hotmail.com — Mon, 13 Dec 2010 12:24:31 GMT

In case you might like an free iPad to help remotely monitor your SQL Servers, 30 iPads are being given away by three DBAs, along with 30 free licenses to Red Gate's SQL Monitor. Check out these links:http://www.sqlservercentral.com/articles/Editorial/71830/ http://scarydba.com/ http://www.brentozar.com/Hurry to enter to win one of these iPads, as the contest ends this Friday. I wish I could enter the contest, but I am not eligible. :(

RE: How Do You Work When You are Not at Work?

mbricker-600840 — Mon, 13 Dec 2010 11:54:22 GMT

Usually I'll get a system or operator generated email and/or page. I'll connect using desptop or laptop VPN/RDP connection to my work desktop or directly to server. Have talked somebody through something once or twice. Have never had to drive into office to take care of an issue. Have reinstalled SQL Server a couple of time remotely with no problems.

RE: How Do You Work When You are Not at Work?

Steve Jones - SSC Editor — Mon, 13 Dec 2010 10:11:05 GMT

For me, email is really the way I hear about things. I have a smartphone, iPad, and multiple machines. On one of those, I'll get a note. It could be a phone call, but that's rare.From there I might call or forward the notice to someone else, or possibly connect with VPN. I might even call and be remote hands for someone if that's quicker.Getting work when you aren't at work is a reality, but it doesn't have to mean you work 40+ hours and then respond to things. I would definitely set boundaries and push back to get time back, and better balance in your life.

RE: How Do You Work When You are Not at Work?

ahperez — Mon, 13 Dec 2010 08:11:08 GMT

Usually someone calls me. Most of the time I can use the remote desktop, very occasionally I have to drive in(14 miles if I'm in town.) If a PC is handy, I prefer that. I can remote access on my android, but it is annoying to scroll around the screen to find things.

RE: How Do You Work When You are Not at Work?

paul s-306273 — Mon, 13 Dec 2010 08:04:52 GMT

The only time I was called on, I had to spend 2 hours on my cell phone.

RE: How Do You Work When You are Not at Work?

streethk — Mon, 13 Dec 2010 06:43:28 GMT

Most of the databases I administer run well without much intervention. Typically when there is an issue I am called on my cell and I RDP via a VPN portal into either my desktop PC or directly to the SQL server and resolve the issue.

RE: How Do You Work When You are Not at Work?

Pierre Knop — Mon, 13 Dec 2010 06:29:58 GMT

Hi allIn our company we take turns to be on support, we generally have 3 x support phones, one on each network, and we get notified via sms depending on what is down. We do check each system where applicable by using the phones ussd short cuts, for some of our applications and in general, it is just to monitor the system. Each system will restart itself in the event of a connectio issue and sometimes we need to restart a specific tasks/job via dial up connection using VPN.The support rota works nice as you end up learning more about everyone else’s jobs as well, and you do not have to be on duty 24/7, only once every other week. And in general you could plan ahead when going away or so.GroetePierré

RE: How Do You Work When You are Not at Work?

pvermeulen — Mon, 13 Dec 2010 04:54:41 GMT

I receive an email alert or a call on my cell phone.Then I dial in with VPN and connect to the server (usually with RDP).

RE: How Do You Work When You are Not at Work?

7-of-9 — Sun, 12 Dec 2010 20:59:18 GMT

I remember all to well when driving in for any problem was the norm. Technological advances has done away with that. All messages and alerts are directed to a smart phone and I can respond using a laptop. Aside from a few occasion when VPN was not cooperating, 99.99 % of my work is done remotely.

RE: How Do You Work When You are Not at Work?

djackson 22568 — Sun, 12 Dec 2010 19:24:23 GMT

Problems with a database? Almost never. The only issues I typically run into are when a backup fails. Our environment isn't monitored by the engineers even though we have two tools to do so. We frequently run out of free space. The other issue is when Legato has a lock on the backup file - always in SQL 2000 so it is becoming less frequent.All issues are handled remotely.I am not only our SQL DBA, though, I also handle about 20 different systems as the only analyst for them. So I get paged or called far more often for issues with systems than databases. SQL Server does not typically stop running, apps do.

RE: How Do You Work When You are Not at Work?

george sibbald — Sun, 12 Dec 2010 12:20:11 GMT

We use blackberrys on which we receive emails. Might receive a call if its something monitored by the operators.home connectivity is either via citrix on my home PC or vpn on a work supplied laptop.last time I had to go into the office to resolve an issue was about 8 years ago.

RE: How Do You Work When You are Not at Work?

gregwilkerson — Sun, 12 Dec 2010 09:42:03 GMT

I go to great lengths to create processes that detect and notify me of issues before anyone notices. I get non-critical notifications (backup failures, etc) via normal email. I get critical notification via text message and email. I get the emails, and of course texts, on my phone.I insure the mail notification systems are functioning by sending regular heartbeat emails (usually one per day).I do not find that connections via anything but a VPN/RDP are useful to trouble shoot most issues. The screen real estate simply isn't there.I have the ability to use my phone as a hotspot.

RE: How Do You Work When You are Not at Work?

cproctor — Sun, 12 Dec 2010 05:35:06 GMT

I receive emails for minor problems and cell calls when its serious. I VPN in and this wotks for 95% of the problems. When I have to go in, luckily I live only 5 blocks from work.Of course when far away on vacation and can't fix via VPN, a long process of talking a staff person through the fix process. Am in the process of having an external vendor provide on-site emergency help but rural Maine limits choices.I connect with my laptop or home desktop. Have been very lucky that a major failure has not ocurred while on a far away trip.

RE: How Do You Work When You are Not at Work?

c.ajitkumar — Sun, 12 Dec 2010 01:59:45 GMT

HI allthis is condition in which every DBA has to live --[b]Work when you are not at work[/b].i generally got the phone call on my cell and then connect the server using VPN from my laptop.Ajit

RE: How Do You Work When You are Not at Work?

aswani2002 — Sat, 11 Dec 2010 22:26:41 GMT

hello,its a very intersted topic :) i normally get a phone call from someone else n use vpn to connect :-)

RE: How Do You Work When You are Not at Work?

tedo — Sat, 11 Dec 2010 19:49:12 GMT

Hi Brad,My company is too tight to give us a blackberry so we need to rely on a call out by some one else if there is an issue. Normally to resolve issues I dial in via citrix.

How Do You Work When You are Not at Work?

bradmcgehee@hotmail.com — Sat, 11 Dec 2010 12:19:40 GMT

Comments posted to this topic are about the item [B]How Do You Work When You are Not at Work?[/B]