February 18, 2015 at 11:24 am
Comments posted to this topic are about the item Stairway to SQL PowerShell Level 9: Objects For Everyone
April 21, 2015 at 11:41 pm
Well rounded post:-). The SQL Server Provider and the SQLPS.exe may be mentioned as it simplifies the coding.
http://hodentekmsss.blogspot.com/2015/04/can-you-use-windows-power-shell-to-find.html
April 22, 2015 at 6:28 am
Whoa. This is way beyond me. I need to go back to the beginning of the series. Thanks.
April 22, 2015 at 4:04 pm
Though I like the combination of PowerShell and SMO, I still believe many basic stuff, such as create db, table, user etc are better-handled via t-sql.
I somehow consider PS (with the help of .net) as a command-line equivalent of SSIS platform, where we can have a better logic to manipulate t-sql modules and beyond.
One area I extremely wish to see in this series is using PS to execute parallel-type of functions, this is very important when handling hundreds or even thousands of sql server instances.
April 23, 2015 at 4:32 pm
Good comments. The series is meant to introduce you to PowerShell and SQL but not to imply that PS and SMO are the replacements for SSMS or TSQL. SMO emits TSQL so there really is no replacement for it. PowerShell in combination with SMO or TSQL is a powerful combination to manage a SQL server.
As for the parallel execution, I will see what I can do to inject this into the remaining levels.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply