Spokane Area SQL Server Users Group

Next Meeting




Application Database Design

  • In-Person @ 906 W Main Ave. Spokane, Washington, United States (map)
  • 05:30 - 07:30 (UTC-08:00) Pacific Time (US & Canada)
  • Language: English

We'll be meeting in the Level Up Classroom at the downtown library for a presentation on application database design by Sam Carpenter. We'll also have updates on our upcoming SQL Saturday as well as chance to meet and network with local data professionals.

Featured Presentation:

Application Database Design

Sam Carpenter Gonimbo

Organizations today require a more stringent database design for their various data dependent applications. A properly designed application database facilitates data analysis, machine learning, security, and more efficient operations within the organization. The goal of this presentation is to give database professionals (database administrators and database developers) a set of tools for working with application developers to create high quality application databases. Developers have relied heavily on object relational mapping (ORM) frameworks to implement database integration and, in some cases, database design. Unfortunately, ORM frameworks often result in sub-optimal databases - both in performance and data integrity. Instead of relying entirely on ORM frameworks for database integration, application developers should work with database professionals to create application databases that meet the following design goals: - Data Integrity - Performance - Improved Application Functionality Here are some key application database features that support the design goals listed above: - Stored Procedure API - Retain Data "Deleted" By Application - Log All Updates With Original Values - Allow "Draft" Data - Surface History To Application User [DEMO] - The presentation will include a walk-through of the T-SQL for an example application database. In addition there will be a demonstration of an application built on top of the application database.

About Sam:
Sam worked for Microsoft for 11 years. He was a Senior Program Manager for SQL Server and Exchange Hosted Services. He was also the co-founder of the online accounting service Subledger.com. Sam has extensive experience working with a multitude of platforms and technologies. Sam moved to Spokane to be closer to family. He enjoys helping people with their technical challenges and developing solutions to difficult problems.




Back to Top