Working with Extended Events will help you become a better DBA. Working with PoSh can also help you in many various tasks to become a better DBA. Combine the two and you just might have a super weapon.
PowerShell to Backup XE Session
Tag: PoSH
Simplified Session Backups
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Deployed Target Metadata with PoSH
This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Deployed Action and Predicate Metadata with PoSH
This article shows a deeper dive that will show how to expose the Deployed Action and Predicate Metadata with PoSH and familiarity with this powerful tool.
Exposing Deployed Event Metadata with PoSH
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper dive will continue in the direction of Exposing Deployed Event Metadata with PoSH and familiarity with this powerful tool.
Extended Event Management Power Tools
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a learning curve, and it may not be the right tool all the time, but it can sure pack a big hit.
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help determine if you are running SQL […]