Mr. Endri XHINA, Managing Director of ICT Education had a presentation at Microsoft Developers Day Conference. 

The conference took place on 20 May 2011, at Hotel Adriatic in Durres, Albania.
The presentation of Mr. XHINA have been focussed on Designing Partitions to Improve Query Performance. The presentation  showed how partitioning have evolved in SQL Server from the SQL Server 2000,  SQL Server 2005 to SQL Server 2008.
Main concepts behind  partitioning have been introduced as well as recommendations on when to implement partitions are given.
A section of the presentation have been dedicated to the management of clustered and non clustered indexes on partitioned tables.

A real life example is presented to show how to create and manage partitioned tables in SQL Server 2008 R2.
The example used Transact-SQL statements to create and manage  the partition table.
To show the new GUI tools to manage table partitioning, introduced with version R2 of SQL Server 2008, some examples are showed as well.

 The complete  schedule of the event follows:

10:00 - 10:15       Keynote (Microsoft Albania)

10:15 - 10:30       Keynote (Prof. Dr. Ilia Ninka, Department of Informatics)

10:30 - 11:10       Advanced customization with SharePoint Designer 2010 (George Capnias)

11:30 - 12:10       Designing Partitions to Improve Query Performance SQL 2008 (Endri Xhina)

12:10 - 12:50       Building Web Sites with Orchard (George Capnias)

12:50 - 13:30       Introduction to Windows Azure and cloud computing(Karl Davies-Barrett)

14:15 - 14:55       Internet Explorer 9 and HTML 5 for Developers (Arben Murtaj)

14:55 - 15:35       Agile Development with Visual Studio 2010 and TFS 2010 (Karl Davies-Barrett)