pdc2008

Microsoft Visual Studio Team System Database Edition: Overview

System — Wed, 29 Oct 2008 16:38:59 GMT

Visual Studio Team System (VSTS) Database Edition enables developers to apply agile practices to the database tier. VSTS takes "One Version of the Truth" for database objects and moves it into source control. See how it interoperates with external data sources like MySQL, Oracle, IBM DB2, and Microsoft SQL Server 2008.

Gert Drapers
Gert Drapers is the Group Engineering Manager for the Visual Studio Team System Database Edition product as known as the “Data Dude”. After 3 years of Ashton-Tate where he was first introduced to SQL Server in 1988, Gert joined Microsoft in 1991. Prior to his current position he was a member of the SQL Server development team where he held various positions varying from development to management. He contributed to SQL Server 7.0, 2000 and 2005; some SQL Server artifacts he worked on are: BULK INSERT, SQL-DMO, SQL Query Analyzer, SQL Profiler, DTS, SQL Agent and SMO. After SQL 2000 he joined the Indigo team where he designed the System.Transactions API and worked on MS-DTC and the web services (WS-AT) transaction specification. In September of 2003 he joined the SQL Server Customer Advisory Team where he focused on helping customers design and implement the largest SQL Server implementations in the world. In July 2005 he started the DataDude project, which goal in life is to provide an offline schema development and deployment environment for SQL Server and other data stores. Right now the team is finishing up the 3rd release of the product! When Gert is not working, he is spending time with his wife and three lovely daughters; loves to cook and make music. Besides that he is serving the SQL Server community by writing tools and articles which are published on http://SQLDev.Net and various magazines.

Microsoft SQL Server 2008: Powering MSDN

System — Wed, 29 Oct 2008 16:38:53 GMT

Hear how the MSDN team created the multi-terabyte system (over 12 million documents) that serves as the core of the web platform and provides integration of content from MSDN and TechNet into Microsoft Visual Studio, Microsoft Exchange Server, and Windows Server. Learn about advanced features like: designs around Blob and associated content from other stores, MERGE delta-processing, Index Filtering, Table Value Parameters, and Data Compression. Everything is demonstrated in the MSDN production system with real-world scenarios.

Mark Johnston

Entity Framework Futures

System — Wed, 29 Oct 2008 16:38:10 GMT

The next version of the Entity Framework adds scenarios in the areas of model driven development, domain driven development, simplicity, and integration. See a preview of production and prototype code for the next version of the Entity Framework as well as a candid discussion with members of the development team.

Tim Mallalieu

Developing Applications Using Data Services

System — Wed, 29 Oct 2008 16:37:45 GMT

In the near future, applications will be developed using a combination of custom application code and online building block services, including data-centric services. In this session we discuss advancements in the Microsoft development platform and online service interfaces to enable seamless interaction with data services both on-premises (e.g., ADO.NET Data Services Framework over on-premises SQL Server) and in the cloud (e.g., SQL Server Data Services). Learn how you can leverage existing know-how related to LINQ (Language Integrated Query), data access APIs, data-binding, and more when building applications using online data.

Mike Flasko

Offline-Enabled Data Services and Desktop Applications

System — Wed, 29 Oct 2008 16:37:47 GMT

The ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. By combining data services with the Microsoft Sync Framework, learn how to create offline-capable applications that have a local replica of their data, how to synchronize that replica with an online data service when a network connection becomes available, and how replicas can be used with the ADO.NET Entity Framework. Also, hear us talk about our plans, see the tools that help client- and server-side setup, and discuss the runtime components and APIs.

Pablo Castro
Pablo is a Software Architect in the SQL Server group at Microsoft. He has worked in various areas of SQL Server and he's currently focused on making data and the web work well together with technologies such as Data Services (Project Astoria).

Project "Velocity": A First Look

System — Wed, 29 Oct 2008 16:38:00 GMT

It is predicted that all large applications will use a distributed data cache as the initial tier for all data access. This session presents an overview of "Velocity," Microsoft's distributed in-memory cache, and shows how it works with IIS, ASP.NET, ADO.NET and SQL Server Data Services.

Murali Krishnaprasad
I am a principal architect of Velocity - the distributed caching platform. Before Microsoft I worked in the Oracle database engine building the object-relational support, XMLDB, XQuery and secure enterprise search product.

SQL Server 2008: Beyond Relational

System — Wed, 29 Oct 2008 16:32:35 GMT

In scenarios like product catalogs, property management, and digital asset management, information is often sparse and semi-structured. Learn how the new technologies in Microsoft SQL Server 2008 enable you to store, update, and query semi-structured data, including: sparse columns, filtered indexes, hierarchyID, and XML.

Michael Rys

SQL Server 2008: Deep Dive into Spatial Data

System — Wed, 29 Oct 2008 16:32:42 GMT

Look at some interesting and unexpected aspects of spatial data, where intuitive expectations collide with the hard realities of geometry and computation. Explore problems such as the ambiguity in spatial constructs, the certainty and precision of spatial calculations, and how types interact with indexes. Beyond understanding, see a demonstration of techniques for dealing with these issues in SQL Server 2008 using both built-in spatial functionality and server extensions.

Isaac Kunen
Isaac Kunen is a senior program manager on the SQL Server engine programmability team. Isaac has recently been concentrating on spatial database support, in addition to working on the SQL Server type system, SQL CLR integration, and database extensibility. Prior to joining Microsoft in 2005, Isaac was a developer at BEA Systems.

SQL Server 2008: New and Future T-SQL Programmability

System — Wed, 29 Oct 2008 16:32:43 GMT

This session covers new 2008 T-SQL programmability features and enhancements for SQL data types, SQL language, T-SQL procedure programming, CLR integration, T-SQL dependency management, globalization, and more. Learn to develop using the new date and time datatypes, table-valued parameters and MERGE that are new in SQL Server 2008.

Michael Wang
My name is Michael Wang, and I’m currently a senior program manager lead in the SQL Server engine application platform product team of Microsoft. My team is primarily responsible for driving & delivering product features and improvements for sever side programmability that covers SQL data types, libraries/functions, SQL relational accessibility, T-SQL procedure programming & logic, SQLCLR, T-SQL supportability,globalization and etc.

SQL Server 2008: Business Intelligence and Data Visualization

System — Wed, 29 Oct 2008 16:32:44 GMT

Learn how to create an entity data model and bind it to data visualization and ReportViewer controls. Dive into new Reporting Services features like: Tablix, new Data Visualization controls, and the new Report Creation experience. Also, preview the future AJAX ReportViewer control and the new RDLC designer.

Stella Chan
I am lead program manager in the SQL Server Reporting Services team. Prior to becoming a program manager, I graduated from Harvard in 1997 with a Ph.D. degree in theoretical physics and joined Microsoft shortly afterwards. My past projects include mainly development of business intelligence applications and data mining algorithms.

SQL Server 2008: Developing Secure Applications

System — Wed, 29 Oct 2008 16:32:59 GMT

Learn what application developers and DBAs should consider to help secure data. Topics discussed include authentication, authorization, execution contexts, and encryption with focus given to the new security features introduced in SQL Server 2008.

Il-Sung Lee
Il-Sung Lee is a Program Manager for the Engine team in the SQL Server product group and is the PM owner for SQL Server Engine Security. Il-Sung has over ten years of experience in the database industry as a developer and a program manager focusing on database security and database communications. His current focus is to advance the capabilities of SQL Server in areas such as authentication, authorization, encryption, audit, and intrusion detection. He has presented at numerous SQL Server and DB2 conferences over the past several years. Il-Sung graduated with an M.Eng degree from McGill University and subsequently worked seven and a half years for IBM in their Information Management group before joining Microsoft in 2005.

Sync Framework: Enterprise Data in the Cloud and on Devices

System — Wed, 29 Oct 2008 16:33:05 GMT

See how synchronization plays a pivotal role in transitioning to a managed cloud environment by creating a central hub of information in the cloud. Using synchronization, organizations can enable more efficient mobile and enterprise-to-enterprise scenarios.

Liam Cavanagh

SQL Services: Tips and Tricks for High-Throughput Data-Driven Applications

System — Wed, 29 Oct 2008 16:33:18 GMT

Learn how to use the Authority-Container-Entity (ACE) concepts to build large scale, high-throughput applications using SQL Services and other cloud-based services.

David Robinson
David Robinson is a Senior Program Manager on the SQL Server Data Services (SSDS) team. David is responsible for a multitude of things including driving product features, code samples, and most importantly demonstrating to customers the value that SSDS and cloud computing provides. David enjoys getting out in the community, presenting on SSDS, gathering feedback, and helping to ensure SSDS meets whatever demands you throw at it. David has also written for MSDN magazine on developing solutions against SSDS. Before joining the SSDS team, David was a Solutions Architect on Microsoft's Health and Life Sciences team. Before joining Microsoft, David held various senior positions with a variety of software and consulting companies. David got his start as a developer at Computer Associates in the early 90's. When not working, David enjoys spending time with his wife and helping her corral their 4 young daughters.

SQL Server Compact: Embedding in Desktop and Device Applications

System — Wed, 29 Oct 2008 16:35:57 GMT

Learn how SQL Server Compact can be used to create data files for your applications, run applications directly from DVD, capture user activity, and sync "back home." Learn the different deployment options, including the newly released 64-bit support and best practices for performance.

Steve Lasker
Steve is Program Manager at Microsoft on the SQL Server Copmact team, working to empower developers to enable their occasionally connected users. For Visual Studio and SQL Server 2008, Steve focused on the design for Sync Services 1.0. For VS 2005, Steve worked on many of the data design time features including the Typed DataSet designer, TableAdapters, Object Binding and the Data Sources Window. Prior to joining Microsoft, Steve was a technical architect with an early internet eCommerce company moving to a consulting firm building web, client and device applications for corporate customers. With an engineering background in the remote broadcasting industry Steve lived the life of the mobile workforce where he gained his passion for the occasionally connected user.

SQL Server 2008: Developing Large Scale Web Applications and Services

System — Wed, 29 Oct 2008 16:32:20 GMT

As a developer of mission critical, large-scale web applications and services, do you worry about supporting large numbers of users with lightning fast response times, scaling to terabytes of data, designing multi-tenant services, as well as the cost of building these applications? If you answered yes, come to this session and learn how Microsoft SQL Server 2008 and other data platform services will help you architect and develop your applications to be high throughput, low latency, and highly available-and yet provide predictability of performance and total cost. We describe proven data architectures, design patterns and practices being used by our highest scale customers who service millions of users every day. We also share our next release plans that will help you understand our roadmap on how we will continue to address the needs of the most demanding large-scale applications.

Hala Al-Adwan
Jose Blakeley
José Blakeley is Partner Architect in the SQL Server Engine at Microsoft where he works on server programmability, database engine extensibility, query processing, object-relational functionality, large scale query processing, and scientific database applications. He joined Microsoft in 1994. Some of his contributions include the development of the OLE DB data access interfaces, the integration of the .NET runtime inside the SQL Server 2005, the extensibility features in SQL Server, and the creation of the ADO.NET Entity Framework in Visual Studio 2008. José has authored many conference papers, book chapters and journal articles on design aspects of relational and object database management systems, and data access. Before joining Microsoft, José was a member of the technical staff with Texas Instruments where he was co-principal investigator of the DARPA Open-OODB system. He received a B. Eng from ITESM, Monterrey, Mexico, and a Ph.D. in computer science from University of Waterloo, Canada.

SQL Server: Database to Data Platform - Road from Server to Devices to the Cloud

System — Wed, 29 Oct 2008 16:32:33 GMT

Cloud-based data services will change the way you develop and deploy applications, and SQL Server technologies are evolving to help you build data-driven solutions that span devices, desktops, servers, and the cloud. Learn how to use ADO.NET Data Services Framework (code name "Astoria"), SQL Server Data Services (SSDS), and the Microsoft Sync Framework. Hear how to build applications that can be deployed using SSDS in the cloud or SQL Server on-premises, and learn how to gain insights using the BI capabilities of Microsoft SQL Server.

David Campbell
David Campbell is a Microsoft Technical Fellow working on Cloud Data Platform technologies. Campbell has been with Microsoft for 14 years working on SQL Server and a number of other database and storage related technologies.
Zach Skyles Owens
Zach Owens is a Technical Evangelist focused on SQL Server and Business Intelligence. He has a background in competitor technologies developing web-based solutions spanning Oracle data warehouses to LAMP e-government applications, and is a recent Seattle transplant from Maui where he was developing medical logistics and intelligence applications.