Sorry, I know that slogan has been used already. Thanks to everyone who showed up for the SMO/Powershell chalk talk at TechEd Barcelona today. Here, as promised, are the demos. Thanks especially to Jeffrey Snover, the "dad" of Powershell for showing up and showing me some neat shortcuts… as I typed. Many of the scripts were written "on the fly" and really need better argument validation and error checking, but they seem to do the job. Some of these come from the SMO chapter in Dan Sullivan and my "A Developer's Guide to SQL Server 2005 " book. Enjoy!
Over 1000 XEvents in SQL Server 2016 CTP2. Here are the new ones.
Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to
2 thoughts on “SMO and Powershell: Better Together, The Scripts”
Thanks Bob for the PowerShell session, i was amazed with the possibilities with PowerShell. I am new to PowerShell, but i can see business benefits by implementing services and communicating to legacy systems by using PowerShell.
Regards,
Jatin
This was a great talk. Bob encouraged me to deal with PowerShell, and his samples (including his profile) are a good starting point for exploring the possibilities of PowerShell.
Greetings from Austria
Walter
Comments are closed.