Click here to monitor SSC
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
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3696 Visits: 3120
If you make the toolset good enough then SQL Server becomes that can be cradle to grave.

It can cope with numpties but in the hands of a master it can perform wonders.

You'd be amazed how many IT professionals don't know how strings work or what an interupt vector is, or have a rudimentary understanding of storage, or latency or a whole host of other nitty gritty details. They simply haven't needed to.

Would they have been better if they did understand the nitty gritty? I'd hope so if they had a desire to become tech leads and architects, but probably not if they had an aspiration for management.

I get the impression that what you are really asking is to be recognised as a skilled professional rather than a replaceable nobody. For that you have to develop soft skills or be golden boy to someone with the soft skills. I know it isn't fair but to quote a song "life's a bitch and then you die".

LinkedIn Profile

Newbie on www.simple-talk.com
Eric M Russell
Eric M Russell
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4629 Visits: 9579
However why do we need to go to the maintenance plan's log? SQL Server includes the job history. It includes maintenance plans. Why doesn't the job understand there is a maintenance plan, read it's log, and return the information? Or give us a button on the job history that loads up the maintenance plan log? That's a simple thing to do, and isn't the job of software to make tasks easier?

This sounds like a useful feature missing from the SQL Server Management Studio application, rather than the database engine or SQL Agent. Perhaps Microsoft has intentionally capped the investment on SSMS, implementing basic management functionality, thinking that 3rd party tool vendors or add-ins will fill in the gaps.
Another feature missing from SSMS 2008/2012 out of the box, something that I consider to be basic, is information schema search. This was included in the old v2000 Query Analyzer. However, Red Gate's SQL Search add-in can be downloaded for free and is even better.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Rod
Rod
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1133 Visits: 1932
As an accidental DBA myself, I give your comments a hearty "Here! Here!", Steve.

Kindest Regards,RodConnect with me on LinkedIn.
Rafael A. Colón
Rafael A. Colón
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 169
Steve, you are right on the money, the user interface of a product like this should be more sophisticated, especially with the prices that we are paying now for licensing.
Rafael A. Colón
Rafael A. Colón
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 169
Steve, you are right on the money, the user interface of a product like this should be more sophisticated, especially with the prices that we are paying now for licensing.
Andy Leonard
Andy Leonard
Mr or Mrs. 500
Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)Mr or Mrs. 500 (513 reputation)

Group: General Forum Members
Points: 513 Visits: 1092
Put a team of 50 people to work on usability and improving the tooling. It will be a great investment for the future.


Or....

Microsoft could license (or buy) the technology from companies that are producing cool solutions to some of these very problems. Just thought...

:{>

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
Peter Schott
Peter Schott
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1035 Visits: 1906
I'm blessed to work with another DBA who subscribes to the ideas behind the "lazy DBA" philosophy - don't work harder/more than you have to. He set up some phenomenal monitoring and alerting around all of our scheduled jobs. If a new job is created, it will soon be modified to send alerts on failure. Those alerts pull out the relevant details about any failures that occurred and send those along with the alert. We have alerts for drives out of space that contain a brief listing of critical DB files on those drives. We get detailed failure notices for replication if it has issues. We even have visibility into basic stats/items running on our servers over a web interface for when it's needed.

I agree with Steve's point that this is one of many areas that could be enhanced. Andy also makes a good point that MS could just buy/tweak an existing solution without too much trouble.

Of course, having read this I think I need to bug my co-worker about putting some of this info in a blog post. It would be really helpful to people who manage quite a few systems.



JJ B
JJ B
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 2846
Amen! From your lips to MS's ears!

Steve, this is the best editorial you have written yet. :-)
kevaburg
kevaburg
Mr or Mrs. 500
Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)

Group: General Forum Members
Points: 584 Visits: 923
Peter Schott (6/19/2013)
I'm blessed to work with another DBA who subscribes to the ideas behind the "lazy DBA" philosophy - don't work harder/more than you have to. He set up some phenomenal monitoring and alerting around all of our scheduled jobs. If a new job is created, it will soon be modified to send alerts on failure. Those alerts pull out the relevant details about any failures that occurred and send those along with the alert. We have alerts for drives out of space that contain a brief listing of critical DB files on those drives. We get detailed failure notices for replication if it has issues. We even have visibility into basic stats/items running on our servers over a web interface for when it's needed.

I agree with Steve's point that this is one of many areas that could be enhanced. Andy also makes a good point that MS could just buy/tweak an existing solution without too much trouble.

Of course, having read this I think I need to bug my co-worker about putting some of this info in a blog post. It would be really helpful to people who manage quite a few systems.


Einstein once said: If you can't explain a subject in simple terms to a layman, you don't know enough about the subject yourself.

Your DBA has mastered that concept and is the DBA every company "should" have. But then, I am sure he keeps himself abreast of developments, makes sure those less skilled have the answers to questions they need in a manner they can understand and realises the importantance of continuation training. That guy deserves that pat on the back but then companies that have that sort of professionalism take it for granted and reason that "he is only doing the job he is paid for".

Easy to use software, less complex practices, the ability to say "well, it isn't my job anyway": What ever happened to good old-fashioned workplace-pride and standards where the individual knew what needed to be done and simply did it?

(Disclaimer: Not in a good mood this morning and feeling very cynical....)
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36232 Visits: 18751
Andy Leonard (6/19/2013)
Put a team of 50 people to work on usability and improving the tooling. It will be a great investment for the future.


Or....

Microsoft could license (or buy) the technology from companies that are producing cool solutions to some of these very problems. Just thought...

:{>


they do this at times. Or have done it in the past. Wink

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
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