PASS Community Summit 2008: Pre-Conference Seminar
SQL Server Data Storage Formats: Internals, Performance and Best Practices
Led by Kalen Delaney
Tuesday November 18, 2008
This session will describe all the different formats available for storing data, including the new filestream data, compressed data and sparse data columns in SQL Server 2008. We'll look at the metadata to determine exactly what is being stored and where, and discuss best practices for choosing the particular type of storage format.
Seminar Leader Profiles: Kalen Delaney
Kalen Delaney has been working with SQL Server for over 20 years, starting with her employment with the Sybase Corporation in October 1987. The first chapter of the previous edition of Inside SQL Server contained all kinds of juicy details about the beginning of SQL Server with Sybase, and the author of the book's first edition, Ron Soukup, was very much involved in the original joint product. Kalen was also there, in the other half of the arena! She was working in Sybase Technical Support when the first OS/2 SQL Server was set up in one of the lab rooms. Those were the days... Although this history is not included with Inside SQL Server 2005, you can find Chapter 1 from Inside SQL Server 2000 here
. Kalen worked Technical Support for Sybase for two years, and then transferred to the Education Department. She taught all the Sybase courses, and was the specialist for the advanced course on Performance Tuning and Optimization. Kalen won Sybase's Instructor of the Year award in 1990. At the time she left Sybase, she had started development on an Advanced System Administration course. In 1992 Kalen became an independent trainer and consultant. Since then, she has worked with both the Microsoft and Sybase companies to develop courses and to do internal training for their Technical Support staff. Kalen was the Primary Subject Matter Expert (SME) for two Microsoft courses: 608: New Features of Microsoft SQL Server 6.5, and 665: SQL Server 6.5 Performance Tuning and Optimization. In 1998 she developed an internal course for Microsoft's product support team, to help them learn the internals and new features of SQL Server 7 and she did something similar for SQL Server 2000. Kalen delivered these courses for many years, to various Microsoft offices and partners around the country and around the world. Today, kalen has her own custom course on SQL Server 2005 Architecture, Internals and Query Tuning
, which she teaches both privately and publicly to clients around the world. You can see her schedule here
. In 1993, Microsoft awarded Kalen with the MVP
(Most Valuable Professional) designation for her participation in the public SQL Server help forums on Microsoft's news server (msnews.microsoft.com). She remains a regular participant on the public forums, especially Microsoft's public news server, answering many questions dealing with SQL Server internals and behavior. Kalen has been writing about SQL Server for over 12 years, in addition to courseware development. She was a coauthor of SAMS' SQL Server 6.5 Unleashed (Oct 96) and SQL Server in 21 Days (Feb 98), also from SAMS. She wrote a regular monthly column on SQL Server Internals for Pinnacle Publishing's SQL Server Professional Journal from October 95 to September 98. Check it out at pinpub.com
. Kalen has written articles for Windows ITPro Magazine (formerly Windows 2000 Magazine), from Penton Media (windowsITPro.com
) In mid-1998 she joined the editorial staff Penton's newest publication, SQL Server Magazine, which made its debut in February 99. Kalen is now writing a regular monthly column as well as frequent articles for this publication. You can get a list of all her articles for SQL Server Magazine here
. On numerous occasions Kalen has been invited by Microsoft to present special internal training. She has spoken at Microsoft Technical Education Conference (TechEd), and worked in the SQL Server Lab at several conferences. In early 1999 she was asked to participate in the original planning committee to form a non-profit, international SQL Server Users' Group. Out of that planning committee, the Professional Association for SQL Server (PASS) was born. Kalen served as the Director of Program Development for the first two years, and spoke at the inaugural conference in Chicago in September 1999. She has spoken at every PASS conference since that time, usually presenting both a pre-conference seminar and a regular conference session. Kalen's academic background centers around UC Berkeley, where she earned a BA in Linguistics and a MS in Computer Science. Her training/teaching career goes back to her graduate school days when she was a Teaching Assistant in the Computer Science 101 courses at Berkeley. Kalen began teaching classes on her own during her last year of graduate school, and then taught for four years at Mills College in Oakland, California. At Mills, she taught the entire range of undergraduate courses, except for compilers. She taught Assembly language, data structures and operating systems, in addition to the basic programming classes. Kalen also developed and taught Mills' first course in database management systems. She then left Mills to return to UC Berkeley as a Lecturer, and taught full time at Berkeley until joining Sybase and her life with SQL Server began.
for PASS Community Summit 2008 and this pre-conference seminar!