Piloting a new format for this user group meeting
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
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.
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
Meet and greet.
18:00 – 18:30 SQL Server 2014 update
Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
18:30 - 19:30 - 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 colum store index
Describe how to traverse data by using indexes.
Describe other indexes.
19:30 - 19:50 - Break
Time for pizza
19:50 - 20:50 - 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 in the North West
20:50 - 21:00 - Feedback, Prize Draw and Close