PowerShell for the occasional DBA
Details
Abstract:
In this session Warren Estes (https://twitter.com/warren2600) will go over how you can use PowerShell to make life easier when dealing with common, and not so common, DBA tasks. Warren will show you how to iterate over instances using SMO to get MSSQL inventory information, SQL agent job results and backup history for reporting. Learn how to leverage the power of dbatools to backup/restore databases, gather diagnostic information, migrate logins/databases and so much more!
Aside from the other Warren (Frame):
Don't skip this just because you aren't a DBA!
• Learning some basics of what a DBA does can be hugely helpful
• Knowing the PowerShell tools a DBA might use could give you a great opportunity to earn good will with your DBA(s)
• You never know what direction you might want to take your career down the line
Boring stuff:
• Be sure to bring a government issued ID
• We'll try to record this, if things work out
• Apologies for booking a Friday, literally the last open slot at the NERD Center in July!
