Data Platform User Group (SQL, Azure, Powershell)

This is a past event

29 people went

Location image of event venue

Details

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at PASS user group events. These events are a really great opportunity to socialise in an informal learning experience.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

17.30 – 18:00 – Registration / networking.
18:00 – 19:00 – Rob Sewell | Validate your SQL Server estate with ease using dbachecks
19:00 – 19:20 – Break (food / drinks).
19:20 – 20:20 – Mark Pryce-Maher | Tiger eam Toolbox
20:20 – 20:30 – Feedback (via Microsoft forms) then off t’pub.

Validate your SQL Server estate with ease using dbachecks | Rob Sewell

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.

BIO
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!

Mark Pryce-Maher - Tiger Team Toolbox

Mark Pryce-Maher is a Senior Premier Field Engineer at Microsoft with lots of database /azure experience.
When not trainspotting, line dancing and hand modelling, Mark spends the majority of his time talking to customers about SQL Server / Power BI and all things data related.

Have you heard about the SQL Tiger Team? Do you know they provide a free set of SQL scripts to help you administer your SQL Server?
In this session, we explore the scripts in Tiger Team Toolbox.
Can't wait for the session?

Download the scripts from here. https://github.com/Microsoft/tigertoolbox