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


SQL Server Should Work for Us


SQL Server Should Work for Us

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

Group: Administrators
Points: 63390 Visits: 19115
Comments posted to this topic are about the item SQL Server Should Work for Us

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
David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7725 Visits: 3287
Bring back Project Barcelona!

LinkedIn Profile

Newbie on www.simple-talk.com
Gary Varga
Gary Varga
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16591 Visits: 6534
I wholeheartedly agree. A small team (even much smaller than 50) could go through loads of small issues which when combined will make SQL Server a much slicker provision. It would be far better that a team are tasked with this as their sole duty otherwise it is these sort of issues that never make it off of the "we'd like to do it but had more pressing issues" list.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
kevaburg
kevaburg
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1610 Visits: 990
What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and understand the inner workings of what they are using. It isn't like being a road sweeper: Simply pick up a brush and sweep.

Without the in-depth knowledge of memory architecture, index management, backup and recovery strategies along with at least basic knowledge of database design how could they hope to perform the job they need to on mission-critical information management systems. And lets face it: Databases represent for most companies a mission-critical investment that helps keep them mobile in a dynamic market.

This is one of the problems Microsoft has had with Windows (but only one Smile). Because via the GUI everything is relatively easy to do, everyone that tampered with a Windows Server called themselves Administrators. They didn't think about the security implications associated with these machines. As long as people could access resources it must be working, right?

Do we really want that sort of attitude with our database servers simply because someone wants something to be made simpler or more intuitive? I find the SSMS intuitive enough. I understand the wording used, I know where to find the information that will help me in my work and I can intelligently argue one opinion against another so that the best solution can be found to a given problem.

I think the best thing that can happen is that these accidental and/or average DBAs realise their need to learn and that bosses realise the need for them to learn.
Gary Varga
Gary Varga
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16591 Visits: 6534
kevaburg (6/19/2013)
What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and understand the inner workings of what they are using. It isn't like being a road sweeper: Simply pick up a brush and sweep.

Without the in-depth knowledge of memory architecture, index management, backup and recovery strategies along with at least basic knowledge of database design how could they hope to perform the job they need to on mission-critical information management systems. And lets face it: Databases represent for most companies a mission-critical investment that helps keep them mobile in a dynamic market.

This is one of the problems Microsoft has had with Windows (but only one Smile). Because via the GUI everything is relatively easy to do, everyone that tampered with a Windows Server called themselves Administrators. They didn't think about the security implications associated with these machines. As long as people could access resources it must be working, right?

Do we really want that sort of attitude with our database servers simply because someone wants something to be made simpler or more intuitive? I find the SSMS intuitive enough. I understand the wording used, I know where to find the information that will help me in my work and I can intelligently argue one opinion against another so that the best solution can be found to a given problem.

I think the best thing that can happen is that these accidental and/or average DBAs realise their need to learn and that bosses realise the need for them to learn.


Valid but unrealistic in my opinion.

Software should be as easy to use as possible but unfortunately a side effect is that people without proper training and experience get the responsibility thrust upon them. Or maybe the side effect is that the software is produce to help those who have this responsibility.

As for mission critical, not all so called accidental DBAs are dealing with mission critical databases. Useful: yes. Important: definitely. Essential: maybe.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
batgirl
batgirl
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1709 Visits: 1820
kevaburg (6/19/2013)
What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and understand the inner workings of what they are using.


In a perfect world, yes.

In reality, DB servers are left unattended when knowledge and talent leave the organization and someone has to step up and learn.

I know how to do a lot of things well but that doesn't mean that I don't deserve tools to help me.
kevaburg
kevaburg
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1610 Visits: 990
Gary Varga (6/19/2013)
kevaburg (6/19/2013)
What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and understand the inner workings of what they are using. It isn't like being a road sweeper: Simply pick up a brush and sweep.

Without the in-depth knowledge of memory architecture, index management, backup and recovery strategies along with at least basic knowledge of database design how could they hope to perform the job they need to on mission-critical information management systems. And lets face it: Databases represent for most companies a mission-critical investment that helps keep them mobile in a dynamic market.

This is one of the problems Microsoft has had with Windows (but only one Smile). Because via the GUI everything is relatively easy to do, everyone that tampered with a Windows Server called themselves Administrators. They didn't think about the security implications associated with these machines. As long as people could access resources it must be working, right?

Do we really want that sort of attitude with our database servers simply because someone wants something to be made simpler or more intuitive? I find the SSMS intuitive enough. I understand the wording used, I know where to find the information that will help me in my work and I can intelligently argue one opinion against another so that the best solution can be found to a given problem.

I think the best thing that can happen is that these accidental and/or average DBAs realise their need to learn and that bosses realise the need for them to learn.


Valid but unrealistic in my opinion.

Software should be as easy to use as possible but unfortunately a side effect is that people without proper training and experience get the responsibility thrust upon them. Or maybe the side effect is that the software is produce to help those who have this responsibility.

As for mission critical, not all so called accidental DBAs are dealing with mission critical databases. Useful: yes. Important: definitely. Essential: maybe.


But we aren't talking about software as such. We are talking about an evolving entity which is what a database is. If I get punched in the stomach I gasp for breath which is exactly what you are doing when you misassign instance memory or don't have a backup when a backup is really needed.

"Valid but unrealistic" is how you put it. Is it unrealistic to pick up a book and read it or for an employer to get a course sorted? I don't think so.

But as long as there are people out there that market themselves as administrators when they clearly aren't (and you only have to look at some of the questions here to identify them) the consultants that get paid a huge amount of money to correct their mistakes will always have a job! So, realistically, where is the benefit to a company that ignore the lack of his adminisrtators knowledge.

To an extent, I agree with you and some of your conclusions. What I can't agree with is the apathy that far too many people have towards a subject that affects (in many instances) how a company reacts in a constantly changing market.
kevaburg
kevaburg
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1610 Visits: 990
batgirl (6/19/2013)
kevaburg (6/19/2013)
What bothers me is the need to have a product that the accidental and/or average DBA can use. DB Servers are maintained by people that have been trained and understand the inner workings of what they are using.


In a perfect world, yes.

In reality, DB servers are left unattended when knowledge and talent leave the organization and someone has to step up and learn.

I know how to do a lot of things well but that doesn't mean that I don't deserve tools to help me.


I'm not talking about not deserving the tools you need to help you. Most of the time the tools you need are an appropriate book and time to practise. As a professional administrator of Oracle and SQL Server databases I understand that in order to look after my companies data well (and it is a big company with a lot of data) I can't afford to not keep abreast of the software I am using. Sometimes that means using some of my own time to learn but it makes me (and other admins) the admins that our organisations deserve.
Gary Varga
Gary Varga
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16591 Visits: 6534
kevaburg (6/19/2013)
...As a professional administrator of Oracle and SQL Server databases...


And that is the crux of the matter.

There are lots of people out there who are responsible for looking after SQL Server installations who are not professional administrators. They may be professionals but professional developers, professional network administrators, professional (I am hoping you get the idea by now)...

Note that SQL Server was originally marketed as a database that did not require a full time DBA. I believe that this may be still true under some circumstances.

Having said that all this is irrelevant.

The tool should be more helpful when it can.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Tony Savoie
Tony Savoie
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1037
The tools should be more refined. Absolutely. Making the tools easy to use and intuitive is a bonus.

If companies put people in charge of their SQL Server platform and are not willing to train them they either dont care about their data as much as they should or they dont know the person in charge doesnt know the platform. It's up to the DBA, accidental or otherwise, to identify the skills gap and come up with a plan, with the business on board, to correct this.

Ignored, they either get lucky, or it becomes a self correcting situation Wink
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