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 and networking
18:00 – 18:10 Sponsor Session.
18:10 – 19:10- First Session - Marcin Gminski (sqlwatch.io) | SQLWatch
SQLWATCH is free and community-driven SQL Server performance monitor, available for SQL Server 2008R2 to 2017. SQLWATCH collects your server performance metrics, database growth and disk space, index statistics and more.
In this session, we will go through the conceptual design, installation, data collection and reports. You can download it free from https://sqlwatch.io/
Marcin is an independent SQL Server consultant specialising in performance, development, disaster recovery and data migrations. Following his degree in Computer Science, Marcin has gained over 15 years of experience and knowledge of technical architecture, data analysis, logical and physical design, coding, performance testing, implementation and support whilst working with SQL Server as well as Oracle and DB2 for global brands like Lloyds Banking Group, Wal-Mart, NHS and Solera Holdings.
19:10 – 19:30 - Break. Time for pizza.
19:30 – 20:30 - Second Session - Rob Sewell Validate your SQL Server estate with ease using dbachecks
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.
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!
20:30 – Feedback and Close and head for drinks down the pub