30/03/2009 10:05:22 AM
In this session we will cover advanced aspects of physical database design such as choice of clustered vs. non-clustered indexes, use of normalization to improve performance, partitioning as a form of indexing, things to consider when working with sparse columns, filtered indexes, indexed views, and partition-aligned indexed views. We will illustrate some of the advanced functionality available in SQL Server 2008 such as missing index DMVs and Database Tuning Advisor (DTA).
[i]As this is the last session for the year, we will also have a general discussion about the year that's been. What we've done right, what we could improve and what you'd like to see next year.[/i]
[b]Speaker:[/b] Victor Isakov (SQL Server Solutions)
Victor Isakov is a Database Architect and Microsoft Certified Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. He is one of the first IT professionals to get the Microsoft Certified Master and Microsoft Certified Achitect certifications globally.
[b]*** IMPORTANT ***[/b]
Please recall that the user group has moved to the following location:
[b]Sydney Mechanics' School Arts[/b]
280 Pitt Street
Sydney NSW 2000
Venue: Sydney Mechanics' School Arts • 280 Pitt Street • Sydney • NSW • 2000 |
Duration 12:00 - 14:00 |
On: Wednesday, 2 December 2009