Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Good Enough

By Steve Jones,

Technology changes all the time in some ways. In others, it feels like we're just trying to do the same thing over and over in a slightly new way. I read Brian Kelley's blog on trouble learning Powershell, and I wasn't surprised. It's not that Brian can't learn Powershell or finds it confusing, it's that he already has skills in another area.

So why switch technologies? I know that I still fall back on VBScript at times because I don't have to think. I can bang out a script quickly to grab files and move them around. I know that it's easy as well in Powershell. I've written a few scripts, but it's not natural enough. I haven't had to bang out enough scripts to get that feeling to make it feel like the first tool I should reach for.

We tend to rely on those things that are comfortable or familiar. They give us a return on our investment, we use them quickly and they are handy. Is it any wonder that it's hard to get developers to change their mindset when working with SQL Server? Dealing with a row at a time, or a step-by-step listing of code is just their natural reaction.

When is it time to switch and learn something new? When does it make sense to make a new investment? 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. Or that it's gaining enough traction that the vendor will stick with it. Unlike English Query, I think Powershell is something that Microsoft will stick with for some time.

Maybe it's time that I abandoned that "good enough" VBScript for Powershell.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

Total article views: 213 | Views in the last 30 days: 1
Related Articles

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.


Learning Powershell

I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my bl...


PowerShell Snippets A Great Learning Tool

When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a...


Small PowerShell Script

I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems...



I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones