SQLNorthEast SQL Server User Group (@sqlne)

Next Meeting

Tuesday,

September

13

SQLNorthEast SQL Server User Group, Tuesday 13th September with Mark Broadbent and Tim Radney

  • In-Person @ 100, Quayside Newcastle, Tyne and Wear, United Kingdom (map)
  • 17:30 - 21:00 GMT Daylight Time
  • Language: English

SQLNorthEast (NEWCASTLE) SQL SERVER USER GROUP


Registration can be done via Eventbrite


Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers or use it as an opportunity to ask for help with any issues that may arise at work.

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

5.45pm – 6:15pm Registration and networking
6:20pm - 7:20pm – Common SQL Server Mistakes and How to Avoid Them - Tim Radney
7:20 - 7:40pm - Break
7:40pm – 8:40pm - Lockless in Seattle: Using In-Memory OLTP Transaction Processing - Mark Broadbent
8:45pm - Feedback and Close

 

Finally: Drinks on the Quayside :)

 

Featured Presentation:

Common SQL Server Mistakes and How to Avoid Them

Tim Radney, Principal Consultant SQLskills

Making mistakes is natural, but learning from them and avoiding them in future takes effort. There's no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he's learned over the years from working and consulting at multiple Fortune-level companies. You'll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You'll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you'll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.

About Tim:
Tim Radney is a principal consultant with SQLskills and a Microsoft SQL Server MVP.

Lockless in Seattle: Using In-Memory OLTP Transaction Processing

Mark Broadbent, DBA SQLCloud

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare? In this session we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.

About Mark:
Mark Broadbent is a SQL Server MCM and Microsoft Data Platform MVP with more than 17 years of experience working with HA solutions. He is the lead to UK's SQLSaturday Cambridge (its first and largest), SharePoint Saturday Cambridge and SQLCambs Chapter. Mark has presented at over 50 SQL Server events, including PASS Summits, SQLBits, U.S. SQLRallys and too many SQLSaturdays to mention. He has received the Microsoft Community Contributor and PASS Outstanding Volunteer awards in recognition of his community contribution.