Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Choosing Your Tasks Expand / Collapse
Author
Message
Posted Thursday, May 12, 2011 9:08 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
Comments posted to this topic are about the item Choosing Your Tasks






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1108174
Posted Friday, May 13, 2011 2:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 1,712, Visits: 1,129
Well, being a developer I get just a little self directed time permitted. To be honest though, I actually take a whole lot more - and to be honest I think that is good for my employer and for myself, as it allows some scope to find better ways to do things. Best not discuss that too openly but just to do it - believe me my employers are not unhappy when they find the excellent new ways to make things work or flashy bits of interface I have come up with.
Post #1108244
Posted Friday, May 13, 2011 3:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:13 AM
Points: 84, Visits: 276
DBAs are often «cost-centres» and self-directed time is often neither understood nor appreciated by those above. It can be hard when one has to account for one's time in 15-minute intervals.

Often one needs to explain what one does in terms of tangible benefits, 'I was working on improving the poor performance of the person search' and the like.

Often those above do not value 'prevention being better than cure' or preparation of technologies as yet unused in the company. You will not spend time learning about replication until we tell you that we need replication fully working within a month.

That being said, I incorporate self-directed time into my tasks. For example, I will wait the appropriate task that is sent my way to hone my skills with the WITH-clause and recursion. I could surely do the task faster the way I had been doing it before but I am thinking medium to long term. With the next such task I can solve the problem faster. I have a list of aspects of SQL Server that is on my 'to be practiced'-list.

It gets harder with something like a cube. One can't just learn all about data-marts, OLAP-types, MDX and DMX in the course of a query that might normally take 2 days to create and test. One would have to build it in one's spare time, populate it with company data, demonstrate it usefully to the right people and then when asked how long it would take to build, repay yourself with the expended time. It's not nice, it's risky but sometimes it's an effective way to introduce whole new features to those that pay.
Post #1108263
Posted Friday, May 13, 2011 6:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:21 PM
Points: 201, Visits: 501
I would expect that as a production DBA that is ultimately responsible for an organization's data, would have large amounts of self directed time ( > 50%) to manage and improve the enviroment as they saw fit. Just my .02


Post #1108356
Posted Friday, May 13, 2011 6:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 8:10 AM
Points: 1,635, Visits: 1,972
At my old job, as a development DBA, I had minimal self-directed time. I was in a dev support role so I had a list of tickets to work on and could choose from those. Unless we were in crisis mode which was most of the time so I had a set prioritization of tickets.

A month into my new job, as a production DBA, almost all my time is self directed. There was an existing DBA that had backups set up and rolling smoothly and I worked with him at my last job before he left so he knows I don't need a lot of babysitting.
Post #1108371
Posted Friday, May 13, 2011 6:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 5:43 AM
Points: 48, Visits: 203
When there were three of us working together, I used to have a lot self-directed time. Since I don't suffer from motivation issues, I could spend a lot of time improving performance, building things to help me manage my time better, and improving my skill set. Now that I'm the only one (like Tigger), I don't know what self-directed time means anymore. Maybe it's the time I spend to refill the water hopper in the coffee pot because it takes five minute for the water to heat up and there's only enough left for one more cup.
Post #1108372
Posted Friday, May 13, 2011 7:22 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 22, Visits: 634
In our environment we are mostly production DBA's, but we are production DBA's on 90% purchased/vendor applications; as such we spend a significant amount of time troubleshooting and rolling out new versions of codes for bug fixes, etc in response to problem tickets from the business users - I do not consider this self-directed.

Part of our problem may be our staffing - we have 2 FTE's and a (new) full-time contractor managing 120 instances over 110 servers, including 12 two-node and three-node clusters; we support over 1000 databases among us. To me this has always seemed like too much per DBA such that we spend most of our time rushing from problem to problem with the duct tape at the ready.

I agree with Steve's original premise that a lot of time for an established production DBA should be self-directed, but I also agree with the few previous posters that point out that businesses usually don't recognize the value in that - mine definitely doesn't.
Post #1108412
Posted Friday, May 13, 2011 9:24 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:27 PM
Points: 4,064, Visits: 5,327
I and my coworkers are combo development/production DBAs and probably 50 - 60 percent of our time is self-directed. We, of course, have production timelines that we work within, but we also come up with a quarterly "to do" list that we can work on as time permits.

Greg
Post #1108544
Posted Friday, May 13, 2011 9:37 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 25, 2014 1:07 PM
Points: 515, Visits: 686
I would say I spend about 25% of my time as 'self directed'. I suspect I could have more time but I am the only DBA here administering many SQL Server instances and Oracle instances as well, so as you can imagine I get many requests. Biggest challange: I have had to learn to learn to mentally 'switch gears' between SQl Server and Oracle as I deal with requests dealing with both.


Post #1108559
Posted Friday, May 13, 2011 1:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 11:59 AM
Points: 323, Visits: 1,465
That being said, I incorporate self-directed time into my tasks. For example, I will wait the appropriate task that is sent my way to hone my skills with the WITH-clause and recursion. I could surely do the task faster the way I had been doing it before but I am thinking medium to long term. With the next such task I can solve the problem faster. I have a list of aspects of SQL Server that is on my 'to be practiced'-list.


That is a great point. I've "practiced" on things like subtle date/time manipulation or filegroups and partitions when I know that type of effort is coming up.

As (T-SQL) developer and DBA, for me it's feast or famine when it comes to self directed time. If we're in the middle of producing a deliverable then self directed time is near 0. When we're between projects and it's only routine maintenance and issues to deal with then that time soars to over half; even 3/4's of working time.

Ken
Post #1108694
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse