http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspxEvery year, PowerShell increases its stranglehold on the Windows Server system and the applications that run upon it – with good reason too. Its consistent mechanisms for interaction between its scripting interface and the underlying systems make it easyenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx#47659Tue, 12 Feb 2013 10:17:42 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47659Phil Factor<p>This is all interesting, but, at the risk of being a bit pedantic, I ought to say that your criticisms of PowerShell should really be aimed at SMO. You'd hit the same problem whatever language you use to drive the SMO .NET library. SMO is doing an object/relational mapping for the SQL Server metadata which is never going to be fast. If you really want performance, you can get the best of both worlds by using SMO for the things it is good for, and use SMO's connection (usually the ExecuteWithResults method but you can do a lot more) to use TSQL to get the more complex information you need. This hybrid approach is dead fast, and as efficient as your TSQL.</p> <p>Examples? Of course! Here <a rel="nofollow" target="_new" href="http://www.simple-talk.com/sql/database-administration/powershell-smo-just-writing-things-once/">http://www.simple-talk.com/sql/database-administration/powershell-smo-just-writing-things-once/</a> </p>http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx#47660Tue, 12 Feb 2013 10:29:55 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47660Rob Farley<p>I'm not meaning to criticise PowerShell or SMO - I find them very useful tools. I find PowerShell extremely handy for getting a wide variety of things done - particularly when T-SQL is just plain clunky (although I think PowerShell can be clunky too, such as in that code for creating Defaults). This post is primarily addressing those people who wonder if PowerShell has access to some secret ability behind the scenes, but I hope doesn't come across as being negative.</p> http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx#48316Tue, 19 Mar 2013 18:01:19 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48316tobi<p>SMO uses deprected stuff all the time as it seem. For example Table.RebuildAllIndexes used DBCC REINDEX</p>