Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reasons to install SQL Server v. 2008R2 versus 2012 on a new server?


Reasons to install SQL Server v. 2008R2 versus 2012 on a new server?

Author
Message
pharmkittie
pharmkittie
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 860
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.
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17529 Visits: 32252
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
pharmkittie
pharmkittie
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 860
Thanks you guys are so helpful and supportive!
MyDoggieJessie
MyDoggieJessie
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4856 Visits: 7363
:-) 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" ;-)
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)SSChasing Mays (641 reputation)

Group: General Forum Members
Points: 641 Visits: 1958
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.
pharmkittie
pharmkittie
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 860
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.
MyDoggieJessie
MyDoggieJessie
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4856 Visits: 7363
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" ;-)
pharmkittie
pharmkittie
SSC-Enthusiastic
SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)SSC-Enthusiastic (171 reputation)

Group: General Forum Members
Points: 171 Visits: 860
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.
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17529 Visits: 32252
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3142 Visits: 3815
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
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