Midlands SQL Server User Group, being held in the offices of Wragge & Co solicitors at 55 Colmore Row in the centre of Birmingham on Thursday 16th May 2013.
Session 1: Thinking Big and Understanding PDW (Parallel Data Warehouse) - James Rowland-Jones (MVP)
Session 2: Improving SQL Server performance with indexing - Richard Douglas
6.00pm – 6:30pm Meet & Greet
6:30pm - 7:30pm Thinking Big and Understanding PDW (Parallel Data Warehouse) - James Rowland-Jones
Do you design and build Data Warehouses? Are you interested in learning about big data design challenges and how you can avoid them? Would you like to know more about Parallel Data Warehouse (PDW), MPP Architectures and Microsoft's Big Data Platform? If so then this is the session for you. We will visit the architectural components of PDW and look at some of the new features available in V2. We will also dive into some of the lessons learned developing systems for PDW in the field. You will leave this session understanding why you should be thinking about PDW for your data warehouse and how you can accelerate the delivery of your PDW project.
7:30pm - 8:00pm Break & Food
8:00pm – 9:00pm How to improve SQL Server performance with indexing
Indexing presents daunting challenges, as it offers countless options to choose from. Even organizing indexes in an optimal fashion can be overwhelming. But with a little help from SQL Server domain expert Richard Douglas, you’ll see how to simplify indexing and improve the overall performance of your SQL Server applications.
Richard will provide step-by-step guidance to help you:
- Find missing and unused indexes
- Resolve fragmentation issues
- Follow the golden rules of indexing
- And much more
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.
Wragge & Co's office is at 55 Colmore Row, Birmingham, B3 2AS, just around the corner from the Old Joint Stock pub.
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 SSUG@PurpleFrogSystems.com
See you in November!
JRJ is a Consultant and SQL MVP for The Big Bang Data Company. His passion is to architect and deliver highly scalable database systems that are creative, simple, and elegant in their design. He has worked for some of the world's largest institutions and been responsible for project delivery worldwide. HIs focus is the Microsoft Appliance Architecture namely PDW and Fast Track Data Warehouse. JRJ is a keen advocate for the SQL Server community. He is a SQLBits organiser and PASS Board Director.
Richard Douglas is a Systems Consultant for Dell where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site www.SQLServerPedia.com which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences.