Network, learn, ask a question, meet other folk, get fed - these are all things that happen at PASS Chapter 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:15 Round Table discussion and Nuggets - ALL Take stock and get the latest news in the SQL Server and Azure Data Platform field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
18:15 – 19:15 - First Session.
19:15 – 19:45 - Break. Time for pizza.
19:45 – 21:00 - Second Session.
21:00 – 21:15 - Feedback, Prize Draw and Close.
Finally: Drinks down the pub.
Getting CI right for SQL Server
Speaker: Alex Yates
Summary: This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.
However, you still haven’t written as many automated tests as you know you should and you aren’t convinced you’re going about it the right way. You haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins, and even if you have you aren’t sure how the process should work for SQL Server builds and tests.
In this session I’ll explain how to use tSQLt to build a suite of automated tests to give you confidence in the quality of your code. Then I’ll talk through various ways to automate your database builds and run those tests on some schedule or trigger. I’ll also discuss the pros and cons of various different approaches so that you can understand which approach would suit your teams and projects.
About Alex: Alex loves DevOps. He also loves databases.
Alex has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyone who researches penguins.
A keen community member, he helps organise the London Continuous Delivery meetup and SQL Relay. He blogs at http://workingwithdevs.com , speaks wherever they'll let him and manages the DLM Digest monthly email: a report on the latest database DevOps news/tutorials.
He's quite fond of nutella. And otters. (Not together.)
Azure SQL Database for the Production DBA
Speaker: Tim Radney (Remote Session)
Summary: Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!
About Tim: SQLskills.com Principal Consultant
Tim is a SQL Server MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.
Full Bio: http://www.sqlskills.com/about/tim-radney/
Microsoft MVP since 2014