Validate your SQL Server estate with ease using dbachecks
16:30 - 19:30
As a SQL DBA you want to know that your SQL Server Estate is compliant with the rules that you have set up.
Now there is a simple method using PowerShell and you can get the results in PowerBi or a report emailed to you on a schedule or embedded into your CI\CD solutions.
Details such as:
• How long since your last backup?
• How long since your last DBCC Check?
• Are your Agent Operators Correct?
• Are AutoClose, AutoShrink, Auto Update Stats set up correctly?
• Is DAC Allowed?
• Are your file growth settings correct, what about the number of VLFs?
• Is your latency, TCP Port, PS remoting as you expect?
• Is Page Verify, Data Purity, Compression correctly set up?
And many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the SQL Collaborative team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it.
About Rob Sewell
Rob is a SQL Server DBA with a passion for PowerShell, Azure, Automation, & SQL (PaaS geddit?). He is an MVP & an officer for the PASS PowerShell VG & has spoken at & volunteered at many events. He is a member of the committee that organises SQL Saturday Exeter & also the European PowerShell Conference. He is a proud supporter of the SQL & PowerShell communities.
He relishes sharing & learning & can be found doing both via Twitter & his blog. He spends most of his time looking at a screen & loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer or flying a drone in the winter.
He has a fabulous beard!