Good Enough

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Good Enough

14 posts, Page 1 of 2

1 2 »»

Good Enough

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Tuesday, May 04, 2010 8:10 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Comments posted to this topic are about the item Good Enough

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #915774

Henrico Bekker

Posted Tuesday, May 04, 2010 11:29 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Hi Steve, I think "abandoning" VBS and PWS might be a bit harsh.
Moving on to new technologies is a definite yes, but still using your "legacy" knowledge is never a bad thing I reckon.

I say, whichever is quicker and more efficient to use, is usually the best way to go.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #915820

OCTom

Posted Wednesday, May 05, 2010 7:01 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:42 PM
Points: 2,012, Visits: 2,839

Ha. I still do things with good old DOS commands. Powershell is just a rehash of command line processing and scripting. Be it DOS and batch files, VBS, AS400, Unix/Linux, etc, command line processing has been a quick and easy way to get certain things done.

Learn Powershell... sure. But, don't think it's anything new. A command line based on .NET is going backward not forward.

Post #916015

Steve Jones - SSC Editor

Posted Wednesday, May 05, 2010 9:06 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Is it going backwards? I'm not sure about that. I think that PWS, and Python, are actually moving forward by bridging some of the programming concepts that were missing in DOS. It's more like making a korn or C-shell for the Windows world.

The big thing for me is that the tools have to be built in. When I'm recovering a server, or rebuilding one, I like having stuff built into the OS and stack. Or easily integrated into an install. PWS does this on newer systems, and as those become mainstream, it becomes more likely that PWS is available.

VBS works well for me, and the big reason I moved away from Perl is that I could always count on VBS being on every server.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #916170

Trey Staker

Posted Wednesday, May 05, 2010 9:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:52 PM
Points: 1,379, Visits: 2,626

I jumped on the powershell bandwagon awhile ago but still go back to other tools (scripting languages). The way I look at it is that it is just another tool on my tool belt. Having more tools on the tool belt allows you to solve more problems or to look at it differently. "When all you have is a hammer, everything looks like a nail."

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Post #916179

Grant Fritchey

Posted Wednesday, May 05, 2010 12:06 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 13,371, Visits: 25,143

I'd say it's time to learn it. There is just so much capability built into it now from MS plugging it into every product they're turning out these days... It just seems crazy to not develop a good skill set in it.

----------------------------------------------------
"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 #916335

Frank W Fulton Jr

Posted Wednesday, May 05, 2010 2:11 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 29, 2013 3:37 PM
Points: 26, Visits: 112

Having been in the computer business for 30 some odd years, the only constant I have come across is that everything changes.

But, then again that is one of the things I love about it, there is always a new challenge.

For me that currently is VS2010 & .Net 4.0, with SQL 2008 R2 just around the corner, the fun never ends!

Post #916456

SQLRNNR

Posted Wednesday, May 05, 2010 4:03 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

It is nice to have some of the old stuff in the old toolbelt - sometimes that just isn't enough or the correct tool. Time to learn the new stuff and possibly become more efficient.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #916550

Jeff Moden

Posted Wednesday, May 05, 2010 11:37 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 32,890, Visits: 26,759

In just about anything I've seen having to do with software, 99% of the people only know how to use 1% of the functionality. A lot of the new flash-in-the-pan software is to try to get the next generation to buy the latest version (gotta keep up with the Jones' Tongue

) with 1 or 2 "slick" things that can usually be done without the "slick" if you just take the time to learn it.

I've seen a whole lot of good functionality in SQL Server simply go away along with some of the good stuff they added... I wonder when they'll add some of it back in so you can buy a new version to get it and think its new and "slick".

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #916671

wldhrs

Posted Thursday, May 06, 2010 6:40 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, December 15, 2010 6:35 PM
Points: 63, Visits: 193

Edited ... oops curly { on a url doesn't make it look like a url :-(

Jeff, you're sounding (reading?) almost as jaded as I am.

However, quoting from our esteemed editor where this list started, "I'd have to say that it's when you see a decent future in the new technology. When it appears that others have proven savings, like a task takes less time or you get better performance."

I'm not sure anyone could prove that that MVS wasn't just the coolest and fastest aproach to re-entrent program execution ever. But that just didn't cut the mustard 'cos MSFT had better marketing for a ***-awful OS and and compilers that worked most of the time.

In all my time with IBM systems I once found a genuine bug with the PL/I compiler.

And for those nerds, who had an anti-M$FT fixation then Linux was the coolest thing out, it just could never support as much hardware as MSFT could, ... oh, maybe that's why MSFT were charging for their products, 'cos they would actually run on just about any hardware on the planet .. well,well, never did think that was a problem until I bought a chinese knockoff of ...

Oops, off the subject. The best marketing wins, not the best technical solution.

I'm sort of hoping that .net (based around c# not vb or x#, he,he) and sql server are going to have the best marketing around 'cos I've sure as hell invested a lot of my life in what I consider a technically very good set of solutions, leaving aside some of the aberrations like asp.net mvc where a forced solution to bad programming has introduced some really weird results. Maybe not wrong, just weird.

And these solutions are evolving very quickly on both a technical language path and a hardware implementaion path, so let's be vveerryy careful about what we define as less time to get better performance.

How many times has everyone out there seen a solution that make the simple stuff simpler but the hard stuff harder.

http://www.artima.com/intv/simplexity.html

When you take something incredibly complex and try to wrap it in something simpler, you often just shroud the complexity. You don't actually design a truly simple system. And in some ways you make it even more complex, because now the user has to understand what was omitted that they might sometimes need. That's simplexity.

- Anders Hejlsberg, Lead C# architect

Peter Edmunds ex-Geek

Post #917544

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions