Performance Tweaking Your SQL Server via PowerShell and Other News
Wow, there’s so much PowerShell news and goings-on that I barely have time to update the blog. Here is a very terse update of some of what’s going on.
Thank you to all of you who joined Amit Banerjee’s presentation yesterday on “You, SQL Server and PowerShell”. You helped us set the all-time attendance record for a PowerShell VC session and that’s the second time we’ve done that this year! We’ve already uploaded the video to YouTube and you can re-watch it here https://youtu.be/3tC3FCvAnNI
I feel the the session should have been called something more like: “Performance Tweaking Your SQL Server via PowerShell” but that’s just me. In any event, Amit has made the scripts available on GitHub.
There’s been a lot of great news about the future of PowerShell+SQL Server lately. Chrissy and I recently interviewed Ken Van Hyning, Engineering Manager for SQL Server Client Tools at Microsoft. Read more here: http://sqlps.io/future
— Ken Van Hyning (@sqltoolsguy) April 14, 2016
We’ve got more great sessions lined up for you already:
Automating Your SQL Server Best Practices Word Document by Laerte Junior, PowerShell MVP
And please don’t forget to help us Up-Vote Connect items so that everyone has a better PowerShell+SQL Server experience!
|Link||Problem / Suggestion|
|http://bit.ly/GetLogin||Basic Login management functionality is missing from SQLPS|
|http://bit.ly/GetSQLAgent||Essential Job support is missing from the SQLPS module; Get-SQLAgentJob & Get-SQLAgentJobHistory etc…|
|http://bit.ly/SSMSPS||Add PowerShell Editor into SSMS|
|http://bit.ly/GetSQLTable||SQLPS Lacks cmdlets to “Get” Common SQL Server Object, Like Get-SqlTable|
|http://bit.ly/1SwqTtA||SQL Server SQLPS PowerShell module fails connection to SQL 2012 instance|
|http://bit.ly/23KqWXZ||SQL 2014 SMO can’t query SQL 2012 instances: “SQL Server WMI provider is not available”|
|http://bit.ly/1QnmscT||Need Documentation for the limitations of a PowerShell step in a SQL Agent Job|
And finally, if you want to collaborate on Connect items and prioritize when they are submitted, please join us on Trello. http://sqlps.io/vote