arnipetursson (11/11/2013) Jeff Moden (11/9/2013)
A talk about how to determine the right tool for the job.
Very cool. I'll start with a bit of a play on words. "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." :-P
Very similar to my mantra (different meaning of course): "Just because you CAN do something in T-SQL, doesn't mean it's a good idea!"
I have to disagree with you on Powershell though.
Because of issues with SCOM, I created a whole suite of powershell scripts for my monitoring and admin needs.
Allowed me to have a single set of scripts that I run from one place, and all I have to do when i set up a new server is add it to my server list tables and set up the login that runs the scripts.
Now I am even monitoring AWS MySQL instances with my scripts.
This is very similar to what i used to do with shell and perl in my previous life as a Sybase DBA.
The one gotcha I have come across with powershell is memory issues, particularly related with how it reads files.
I'm not suggesting that Powershell is a bad thing. Even I use it.
My response was because someone asked if something else had been abused like Recursive CTEs, Cursors, CLR, etc and the answer is "Yes"... like any shiney new object in SQL Server, Powershell has been seriously abused/misused. Most of the people that are doing the abusing seem to be those who know how to program and not much about SQL Server. There are a couple that do know SQL Server quite well but insist on doing simple things using Powershell just because they can.
is pronounced ree-bar and is a Modenism for R
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs