Aug 28, 2017
6:00 pm - 9:00 pm
Alpha Loft - Manchester
How big should the page file be for Windows Server 2016? How many data files should have? What trace flags should we use by default now?
These are questions you addressed long ago in your setup checklist. You’ve spent a lot of time with that checklist, and you’re sure it’s perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? How about the soon-to-be-released SQL 2017? Change is hard, and DBAs need to constantly challenge yesterday’s best practices to ensure they meet today’s business needs.
Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.
Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
6:00-6:30 – Networking & Pizza provided by Alexander Technology Group
6:30-6:45 – Announcements
6:45-8:00 – Feature Presentation
8:00-9:00 – Discussion & Networking
September 25 in Portsmouth
October 28 in Manchester – Taiob Ali – Think Like the Cardinality Estimator
November 27 in Portsmouth – Andy Mallon