San Francisco, California
London, United Kingdom
Midlands SQL Server User Group - 15h January 2015, 6.30pm
Session 1: Indexing Power Hour - Chris Testa-O'Neill
Session 2: Indexing Power Hour - Lab
Be sure to bring your laptops charged up with SQL Server Database Engine and AdventureWorksOLTP database installed as Chris Testa-O'Neill takes you through an hour of indexing, followed by an hour with SQL Server MVPs, MCMs and Highly experienced mentors taking you through the lab that follows.
6.15pm – 6:30pm Meet & Greet
6:30pm - 7:30pm PART I: Indexing Power Hour - Chris Testa-O'Neill
If you understand how SQL Server accesses data, you can create indexes to facilitate the searching of data. One of the important aspects of database operations is the users’ perceived access to the data and you should create the right type of indexes on the right columns in the right tables
- Describe how SQL Server retrieves data.
- Describe a heap.
- Describe a clustered index.
- Describe a non clustered index.
- Describe a columnstore index
- Describe how to traverse data by using indexes.
- Describe other indexes.
7:30pm - 8:00pm Break & Food
8:00pm – 9:00pm PART II Indexing Power Hour - Lab
Highly experienced SQL Server mentors will take you through a 1 hour lab that reinforces the session from before. With an opportunity to get 1-1 support from some of the best SQL Server professionals around
We'll be at the Midlands Art Centre (MAC Birmingham), B12 9QH.
It's directly opposite Edgebaston Cricket Ground in Birmingham
Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground
Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.
The 45 & 47 are the best options, which depart from outside Boots in the Bullring, opposite where the main entrance to New Street station was, on Smallbrook Queensway.
Room: When you get there, we're in the 'Pincent Masons 1' room. On the 1st floor, above the main entrance.
We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.
Dress code: relaxed
If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email Alex@SQLMidlands.com
Chris Testa-O'Neill is the founder and Principal Consultant at Claribi. An experienced professional with over 14 years’ experience of architecting, designing and implementing Microsoft SQL Server data and business intelligence projects at an enterprise scale. He has significant experience of leading and mentoring both business and technical project stakeholders in maximising investment in SQL Server and more recently in Azure solutions.
A regular and respected speaker on the international SQL Server conference circuit, and an organiser of national SQL Server conferences and events, Chris has been recognised as a Microsoft Most Valuable Professional (MVP) by Microsoft. and has been a Microsoft Certified Trainer (MCT) for the last 14 years having both authored and delivered Microsoft Official Courses.
When & Where
SQLMidlands - Bringing the West Midlands SQL Server community together
We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.
We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.
If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!
This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!