Leonard Lobel

Programming Beyond Relational Features in SQL Server 2008

Date: This event took place live on August 19 2010

Presented by: Leonard Lobel

Duration: Approximately 75 minutes.

Cost: Free

Questions? Please send email to


Leonard Lobel will guide you through detailed demos that showcase the new "beyond relational" features introduced in Microsoft SQL Server 2008.

We'll cover FILESTREAM, and learn how database developers can now enjoy the native ability to store large binary objects in the file system with full transactional integrity. We'll also build several applications that integrate location-awareness by leveraging the new geospatial data types. Finally, you'll see how to use the new hierarchyid data type to cast a hierarchical structure over any relational table against which you can easily perform hierarchical queries and tree manipulations.

About Leonard Lobel

Leonard Lobel is a principal consultant at twentysix New York, a Microsoft Gold Certified Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions with experience that spans a variety of business domains including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and a frequent speaker at local user group meetings, VSLive, SQL PASS, and other industry conferences. Lenni is lead author of the Microsoft Press book "Programming Microsoft SQL Server 2008", and can be reached at lenni.lobel@26ny.com