Dr András Belokosztolszki
András Belokosztolszki is a software architect at Red Gate Software Ltd. He is a frequent speaker at many UK user groups. He is primarily interested in database internals and change management. At Red Gate he has designed and led the development of many database tools that compare schemata and enable source control for databases (SQL Compare versions 4 to 8), refactor databases (SQL Refactor) and show the history of databases by analyzing the transaction log (SQL Log Rescue). András has a PhD from Cambridge and an MSc and BSc from ELTE, Hungary.
SQL Server 2005 and 2008 both introduced many language elements that simplify complex queries. In this session we will look at a number of less frequently used, but very powerful T-SQL features like PIVOT, ROW_NUMBER() and MERGE.
What does it mean that my index is fragmented? Why do I get a warning about index record sizes? How should I store images in SQL Server? Knowing how SQL Server stores data and what options there are to control this can help you to build more efficient applications. In this session we will look at how table and index data is stored on disk. We will look at the various data types available, from bits to filestreams, how indexes can be used to optimize read or write performance, and how row and page compression work.