Add oil to fire: SMO and Monad — a flammable combination


Euan pointed me to an interesting article about the use of Monad together with SMO. Those who know me well, know I am somewhat of a scripting biggot and still install Cygwin on all of my boxes as I cannot live without bash, awk, perk, sed, expr and the various other UNIX tools that I have used over the years. I have been somewhat of a Monad sceptic, but once I saw what the vision behind it was I was quickly turned around. Now history will tell whether MSH is going to be the big hit I expect it to be. But there are several teams here already deeply investing in it and Exchange is a team that already showcases a deep use of Monad and event built their management UI on top of it. SQL Server DBA’s have potentially a lot to gain from a good Monad implementation with a set of well implemented cmdlets*.


I’d love to know what type of cmdlets you’d like to see for SQL Server/SMO, bye the way… This is something we’re looking into for the next release.


 


*If want to know what a cmdlet is, take a look at this deck or this MSDN article.

Comments (13)

  1. Duncan Godwin says:

    There’s an initial take on msh/smo here:

    http://pluralsight.com/blogs/dan/archive/2005/12/29/17703.aspx

  2. Chip says:

    Why do you install CYGWIN instead of SFU?  Just curious.  I have scripts written in Korn shell, so I prefer SFU.

  3. mwories says:

    I happen to be a long term bash user. Just happen to like the environment, but there is no reason I should not be able to use SFU… Just did not have the cycles to install it.

  4. Vasu says:

    I think an article on how to use SMO with Monad is in order, hopefully from the horse’s mouth (SQL team 🙂 ). The pluralsight article is ‘nice’ but uses a lot of deprecated functions (LoadWithPartialName).

    Currently I am working on something that is using this and I found there was no (google)known reference to anything other than the pluralsight article.

    Deprecated functions, are another form of hacked way of doing things on a command line where things should never change, but it is there..

  5. DBMwS says:

    I have just started to play around with SMO.  In my opinion, PowerShell has been really useful without getting my hands too dirty with VS 2005, initially.

    Getting familiar with SMO through simple PowerShell script would definately increase more DBAs or developers to get to know SMO and see how powerful and flexible it is.

    As of 07/28/2006, I am still not seeing examples of using SMO through powershell(except the one done by Dan Sullivan.

    I am looking forward to more SMO examples in powershell to automate some SQL Server tasks.

    > bye the way… This is something we’re looking into for the next release

    I just can’t wait! 😉

  6. star tattoo says:

    The star has numerous meanings depending on who is wearing it. For some it may signify honesty. For others it is a symbol of hope and beauty. Star tattoo ideas from person to person. The number of points the star contain is the most meaningful way to personalize it. A particular color of the star is also a very great way to personalize your star tattoo. While the most common types of stars are the 4 pointed and 5 pointed stars, other star tattoo ideas are out there if you look hard enough.

    http://xcrssabg.007webpro.com/star-tattoo.htm

  7. Coco says:

    Some education links.

    [url=http://www.geocities.com/harveymcclain07/car-decal-sticker-window.htm]car decal sticker window[/url]

    [url=http://www.geocities.com/harveymcclain07/car-window-decal.htm]car window decal[/url]

    [url=http://www.geocities.com/nestorbrennan87/bose-speaker-for-i-pod.htm]bose speaker for i pod[/url]

    Please delete this message if it wasn’t interesting for you.

  8. kohlscodes says:

    <a href="httpwwwevzvhqkucnpage1html">ensemblesdemeublesdechambre224</a> ensemblesdemeublesdechambre224,<a href="httpwwwevzvhqkucnpage3html">whenjesuscomesbacktoearthhowlongwillhestay</a> whenjesuscomesbacktoearthhowlongwillhestay,<a href="httpwwwevzvhqkucnpage6html">candyfrenchchew</a> candyfrenchchew,<a href="httpwwwihamuicscnpage93html">pediatricresearch1995</a> pediatricresearch1995,<a href="httpwwwihamuicscnpage93html">pediatricgroupinbatonrougelouisiana</a> pediatricgroupinbatonrougelouisiana,<a href="httpwwwihamuicscnpage91html">macvoicechangingsoftware</a> macvoicechangingsoftware,<a href="httpwwwevzvhqkucnpage16html">johnpelosi</a> johnpelosi,<a href="httpwwwevzvhqkucnpage4html">yamaha50ccjog</a> yamaha50ccjog,<a href="httpwwwevzvhqkucnpage7html">issueswhystudentshouldbeallowedtobringipods</a> issueswhystudentshouldbeallowedtobringipods,<a href="httpwwwevzvhqkucnpage11html">imagesofcomputersinuse</a> imagesofcomputersinuse,

  9. <a href="httpwwwnxedpuuecnpage59html">whywererabbitsinconcentrationcamps</a> whywererabbitsinconcentrationcamps,<a href="httpwwwnxedpuuecnpage50html">wheretobuycheaplacosteshirts</a> wheretobuycheaplacosteshirts,<a href="httpwwwnxedpuuecnpage67html">ismomteamlegitimate</a> ismomteamlegitimate,<a href="httpwwwnxedpuuecnpage57html">vanrentalmalaga</a> vanrentalmalaga,<a href="httpwwwnxedpuuecnpage69html">jessicagoldapple</a> jessicagoldapple,<a href="httpwwwnxedpuuecnpage67html">isgreatfunmembershiplegitimate</a> isgreatfunmembershiplegitimate,<a href="httpwwwnxedpuuecnpage79html">pennsylvaniamapsbinghamhawley</a> pennsylvaniamapsbinghamhawley,<a href="httpwwwnxedpuuecnpage53html">renaultcliohihgrevproblems</a> renaultcliohihgrevproblems,<a href="httpwwwnxedpuuecnpage50html">lacostenurseryinduxburyma</a> lacostenurseryinduxburyma,<a href="httpwwwnxedpuuecnpage73html">toplessgirlinmovieeasymoney</a> toplessgirlinmovieeasymoney,

  10. begoniasorg says:

    <a href="httpwwwyleaqeaacnpage62html">jfkassassinationabc</a> jfkassassinationabc,<a href="httpwwwyleaqeaacnpage53html">crandechemin233</a> crandechemin233,<a href="httpwwwyleaqeaacnpage62html">abcafterschoolspecialstitles</a> abcafterschoolspecialstitles,<a href="httpwwwyleaqeaacnpage51html">diabetesagenciesincecilcountymaryland</a> diabetesagenciesincecilcountymaryland,<a href="httpwwwyleaqeaacnpage42html">ctsbumpsldomnatlonclassictrucgearheadspeclali</a> ctsbumpsldomnatlonclassictrucgearheadspeclali,<a href="httpwwwyleaqeaacnpage67html">begoniasuperkurl</a> begoniasuperkurl,<a href="httpwwwyleaqeaacnpage43html">dwarfevergreenshrubs-georgia</a> dwarfevergreenshrubs-georgia,<a href="httpwwwyleaqeaacnpage50html">canadajeepparts</a> canadajeepparts,<a href="httpwwwyleaqeaacnpage43html">bluesageshrub</a> bluesageshrub,<a href="httpwwwyleaqeaacnpage63html">mahjonghotfreegamescashprizes</a> mahjonghotfreegamescashprizes,

  11. <a href="httpwwwmenhzyjdcnpage26html">phoneservivethatusedtobecalledlifeline</a> phoneservivethatusedtobecalledlifeline,<a href="httpwwwmenhzyjdcnpage39html">toriamosyesanastasia</a> toriamosyesanastasia,<a href="httpwwwmenhzyjdcnpage44html">minilstbodies</a> minilstbodies,<a href="httpwwwmenhzyjdcnpage30html">bruceedwardscbccorrespondentinturkey</a> bruceedwardscbccorrespondentinturkey,<a href="httpwwwmenhzyjdcnpage48html">titshandjob</a> titshandjob,<a href="httpwwwmenhzyjdcnpage48html">handjobinstructions</a> handjobinstructions,<a href="httpwwwmenhzyjdcnpage46html">bustyadventuresanita</a> bustyadventuresanita,<a href="httpwwwmenhzyjdcnpage27html">nikeshoes643mens</a> nikeshoes643mens,<a href="httpwwwmenhzyjdcnpage37html">jessiedavisstarkcountyohio</a> jessiedavisstarkcountyohio,<a href="httpwwwmenhzyjdcnpage45html">writtenmessagesinorganisations</a> writtenmessagesinorganisations,

  12. Printingblue says:

    Printingblue is the printing company that offers sticker printing services at discount price, cheap bumper sticker printing, Static Clings, Vinyl Sticker Printing