Chad Miller put out a new SQL Server PowerPack for Quest’s free PowerShell tool, PowerGUI, which got me to thinking – I wonder if there’s been more PowerShell adoption lately?
[poll id=”2″]And because the results can get skewed by job description:
[poll id=”3″]Thanks for taking the time to answer! Your feedback is a giant wooden stick that, depending on its content, will either be used to beat me up or beat up others.
If you’re using PowerShell, I’d love to hear about it in the comments – especially how it’s saved you time in your day-to-day work.
3 Comments. Leave new
We had Chad speak at OPASS at a out last meeting and he does an excellent job presenting on PowerShell. He covers a lot, so be prepared to do some more study if you haven’t used PowerShell. He made me reconsider how I viewed PowerShell with SQL Server. I’m in a small shop (1 production SQL Server) so I don’t have a lot to automate, but there are definitely areas where PowerShell can help.
I have been using Python (and lately IronPython) for many years as an management / DBA scripting language, and it has worked very well in the role. With the primary advantage of PS being “closer” to the engine, I need to what the trade offs are in comparison.
Very nice system, but implementing it in any but a VB-form or C-form language was a huge mistake.
I don’t live in my Mom’s basement. I don’t have time to work through some new arcane syntax. I’m interested only if I don’t have to relearn something I shouldn’t have to relearn. Had VBScript or JScript been extended, or C# or VB.net been implemented as a scripting language, I’d be interested.
As it is, I’ll write my own CLI utilities using my own libraries in C# rather than take the very, very precious time to work out something new.
As usual, Microsoft fails to learn the lesson learned by IBM in the fifties when they made their mainframes compatible with existing card readers. It’s not about the best technology. It’s about what’s compatible with current technology. IBM won. In the long run, do you think Microsoft will?