Mark Abramson

Speaking Sessions

• Accelerate your database development with Object-Relational Mapping (OR/M) in .NET

  9:45 AM Saturday   Room: 8401

  <p><b>Wish you could just "txtName.Text = Customer.Name;" instead of creating a SQL Data Connection or writing stored procedures?</b></p> <br/> <p>Object relational mapping addresses the "impedance mismatch" between object-oriented software and relational persistent storage. They can add many benefits to software development including faster development, reduced cost, fewer "plumbing" errors and more. We'll survey the marketplace, go through some real life examples, and review some of the costs and benefits of each approach. It will be a lively, engaging and interactive presentation -- presuming you are interested in software development and databases, that is!</b></p> <br/> <p>ORMs have the potential to dramatically increase developer productivity while creating clear separation of concerns between layers of an application. While not the right fit for every application, they have gained significant traction in the marketplace and have tremendous support in the industry. They can also have steep learning curves, snarl performance and create headaches for DBAs.</b></p> <br/> <p><b>The session will feature discussion, Q&A and real life examples with C#, Visual Studio 2010 and a few ORM Frameworks (both open source and commercial).</b></p>

• Introduction to Database Design with Entity Relationship (ER) Diagrams

  9:15 AM Sunday    Room: 5501

  <p><b>Developer working with a database? Need to build a data-rich application but not sure how to design your DB? Did someone hand you a legacy DB app and now you have to modify the database schema?</b></p> <br/> <p>This session will cover the basics of designing and setting up a database schema. We'll start with defining a few common business scenarios, build out some tables, create relationships and then go through usage, pitfalls, problems and design tradeoffs. As a veteran of many, many database-driven projects for consumer desktop software applications, websites and enterprise software systems, the database design plays a crucial role in the success of your project.</p> <br/> <p>We'll run through some real-life examples and issues such as:</p> <ul> <li>Creating a new table</li> <li>Choosing data types</li> <li>Normalization (and when to denormalize)</li> <li>Types of relationships</li> <li>Referential integrity</li> <li>join/relationship tables</li> <li>1-to-many, many-to-many</li> <li>...and then how to actually use these structures in your application</li> </ul> <br/> <p>Note: while the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database.</p> <br/> <p><b>Please use the "Email Speaker" button to send me your questions, where you're at with DB design now, or any other material so I can tailor the presentation to your needs!</b></p>