It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world!
It’s all my fault
I’ve been spending a lot of the time I could have been using to write blogs to write articles instead. I’ve been trying to get the word out about all the new cmdlets and all the new things you can do with SQL PowerShell. Or even, the old things you can now do more easily than ever with SQL PowerShell!
It’s going to get worse before it gets better
True. I have three articles I’m working on right now “mostly” done, and a fresh issue to write about popped up on twitter today. But none of the articles are ready to go off to the editors, which makes a now a good time to tell you about the articles that have already been published, before the next wave hits! Not to mention I have a few ideas for commands to contribute to dbatools that I’ve been meaning to get to.
Recent SQL PowerShell Articles
(in chronological order)
- Handy features of the dbatools Read-DbaBackupHeader command
https://www.sqlshack.com/handy-features-dbatools-read-dbabackupheader-command/ - Where[-Object] clauses for people who use SQL Server
https://blogs.technet.microsoft.com/heyscriptingguy/2017/01/04/where-object-clauses-for-people-who-use-sql/ - Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
http://www.sqlservercentral.com/articles/PowerShell/151510/ - Nearly everything has changed for SQL Server PowerShell
https://blogs.technet.microsoft.com/heyscriptingguy/2017/01/25/nearly-everything-has-changed-for-sql-server-powershell/ - PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server
https://www.mssqltips.com/sqlservertip/4678/powershell-invokesqlcmd-outputs-datatables-you-can-insert-into-sql-server/ - Add, Remove, and Get SQL Logins, New SQL PowerShell 2016 cmdlets
https://www.mssqltips.com/sqlservertip/4697/add-remove-and-get-sql-logins-new-sql-powershell-2016-cmdlets/ - Get Last Nights Failed SQL Server Agent Jobs from Multiple Instances with PowerShell
https://www.mssqltips.com/sqlservertip/4707/get-last-nights-failed-sql-server-agent-jobs-from-multiple-instances-with-powershell/ - PowerShell Commands for SQL Server Reporting Services
https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/
There you have it, 7 8 article about SQL PowerShell so far in 2017 and more to come “soon”.
But on the Bright Side
Thanks to the SQL Tools Team, I have a lot of cool new SQL PowerShell stuff to keep writing about!
The post Recent SQL PowerShell Articles I Have Written first appeared on SQLvariations: SQL Server, a little PowerShell, maybe some Power BI.