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 Round Table discussion and Nuggets - ALL
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
It's also a great opportunity to share your knowledge and gain exposure in the
industry by giving a short 1 - 6 minute "nugget" demo/tip.
18:30 - 19:30 - Indexing Power Hour -
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.
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
Finally: Drinks down the pub