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

Reasons to install SQL Server v. 2008R2 versus 2012 on a new server? Expand / Collapse
Author
Message
Posted Saturday, March 8, 2014 10:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 16, 2014 8:06 AM
Points: 72, Visits: 447
Actually the wife (who is an employee) told me not to talk to him because he's "busy". He does much of the work at home and orders the equipment through his business (he consults so he's self-employed). He's paid to do the work because they know him through the wife. He doesn't know databases at all. He installed the software by clicking "next" and accepting the defaults. She knows the Windows operating system through her work with networking them and I think she's going to be fine with taking on the system administration role to grow her career. She just needs to get over herself and give me the rights I need to do my job as DBA and web administrator. She "hates programming" so she wants me to do that. Unfortunately she wants to carve out too much of the DBA role (transactional replication! Get real.) for herself but says she doesn't want to be a DBA. She is junior to me in rank and in the first 3 years of her IT career but, because the executives are not technical they do not know what to do about this situation. Because she already has all the access and power things stay that way until I convince them otherwise.

Because I've been setting up everything on my own laptop (?!) to show them .Net interfaces to SQL Server,SSRS, etc. to demonstrate what I'll move to the server when I have the proper privileges, I have leverage. They love the prototypes and I have been telling them I will move it all to server so they aren't connecting to my laptop to look at reports and enter data,etc. They know that if I take the laptop home they don't have access to the stuff until I VPN in. They still get a glazed look on their faces when I say that I've set everything up on my laptop as if if were a server but that it's slower, non-robust, etc.

But things have been trending my way with various personnel developments so maybe all will be ok soon.
Thanks for your support and counsel.
Post #1548978
Posted Saturday, March 8, 2014 12:21 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 15,637, Visits: 28,021
Best of luck. You know where to go if you need more help.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1548985
Posted Saturday, March 8, 2014 12:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 16, 2014 8:06 AM
Points: 72, Visits: 447
Thanks you guys are so helpful and supportive!
Post #1548990
Posted Saturday, March 8, 2014 4:45 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 3,894, Visits: 7,138
I think we've all been in a similar situation so stay positive and don't get personal, stick to the facts and what's best for the company (and your role as the DBA)

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1549011
Posted Tuesday, March 11, 2014 1:44 PM
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: Tuesday, August 19, 2014 9:08 AM
Points: 550, Visits: 1,610
Are the higher-ups aware that the now have an employee in-house with the applicable skills to install and maintain "the database"? They may not understand technology, but I would hope they understand billed time for consultants.
Post #1549925
Posted Tuesday, March 11, 2014 2:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 16, 2014 8:06 AM
Points: 72, Visits: 447
Yes they are aware that I'm here but they don't understand why I might be needed for this role. It is mega frustrating. They think being a DBA only means the person who develops the repository that will help them automate their existing paper and Access (without any VBA code) processes. The weird thing is that my work is well respected and I STILL don't have enough pull to get the access I need to be the DBA yet. I have been putting everything on my work laptop in lieu of a server so that i can go ahead and start working on the system. The cost of the consulting possibly doesn't matter to them. Also all hardware is ordered through his company without any consultation with me about what we may need. This issue has taken what should be a very rewarding position and made it a stressful and at times unpleasant one. My boss keeps saying he will speak to external people to see what he should do so it's a roll of the dice as to whether those external experts will be experts in this arena. They could end up being high level experts in some other area. There are so many variables that make this a difficult proposition. I wrote up the reasons I need access but there are other higher priorities for my boss now. He really doesn't have any idea about why SQL Server needs a DBA but Access doesn't.


Post #1549939
Posted Tuesday, March 11, 2014 2:33 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 3,894, Visits: 7,138
If it were me, I'd give it an "internal" deadline - meaning, pick a date that things need to change by and then make the decision to give your boss that ultimatum. In the mean time, I'd be evaluating new DBA opportunities to have possibilities in the works...if you're a DBA (and that's your passion) you're not going to be happy in a position like this for very long and it's tough having to drag pre-existing baggage up the hill all the time...

You could also take another approach. Find a new angle. Find something existing business process that's currently in place that takes up significant company resources and find a way to drastically improve it using SQL Server. Present your work-of-art to the powers that be with the slight that "if given the opportunity, these are the kinds of things we can do here with SQL server" and see if they bite!


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1549944
Posted Tuesday, March 11, 2014 4:48 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 16, 2014 8:06 AM
Points: 72, Visits: 447
Thanks for posting again MyDogJessie. Yes, this a very good approach. In a way I been doing this and I've made some headway but , because I developed them on my laptop my boss doesn't see what the big problem is because I have already done the work. I've told him that it's not backed up unless I do it myself with my external drive from home and that it's not robust, can be disconnected to take home,etc. He's able to say "Let's do this in Access" though so that's his way of dealing with it. I don't want to develop in Access. I paid my dues.

You're right that this can't continue indefinitely. It's extremely important to me to do database administration. I'm willing to do other things to accompany it but I do want to keep growing in DBA work. They call me "DBA" but, like I said, they don't know what DBA work is. I did not know this on the interview. I was told I could build the servers but the jr. network admin made sure to freeze me out before I got in the door. She's on leave now so I think my boss is waiting until that's over before making a decision. Meanwhile two servers sit there without anyone using the SQL instances. The network admin doesn't want to be a DBA so that's not the reason. I'll post again if anything new happens one way or the other. Thanks again.


Post #1549982
Posted Tuesday, March 11, 2014 5:25 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 15,637, Visits: 28,021
Maybe get them a copy of Craig Mullins book, Database Administration. It's an awesome overview of the job. It doesn't get into technologies directly, just responsibilities and concepts. I realize handing your boss a book is nuts (although I've done it), but having the reference, open in front of them, as you say, "Well, it's accepted practice that a DBA will do X because of Y" might help a little. Plus, it's a great reference.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1549985
Posted Wednesday, March 12, 2014 3:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 2,869, Visits: 3,210
So your organisation has a non-employee installing software on company machines. IMHO not a good situation.

At the very least you can organise a meeting with your manager, the manager you have in common with the system administrator, and the system administrator and put your case across (in a very calm and dignified manner!). A major aspect of this should be governance and separation of responsibilities.

It is part of the job of technicians to advise managers, and for managers to make the final decisions and take responsibility for them. If your managers say the way things have been done is the way they want it done in the future, your position is clear. You can then decide if your career is best served by staying in place or getting a different job.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1550116
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse