Paul Nielsen

World-class database design and SQL development expert: author SQL Server Bible series (Amazon Best Sellers), 12x Microsoft Data Platform MVP (2004-2016), Microsoft Certified Master program T-SQL instructor, author and presenter of Smart Database Design Seminar in 7 countries, developer of SQL Server T-SQL certification tests and courses for Microsoft Learning.

• 35-year track record of solving complex database design and difficult development problems for clients - history of completing database projects that were previously failures by other consultants.

• Expert in database design patterns. Extensive research and results with object-oriented, graph, and temporal database designs and queries.

• Designs databases for a practical balance of proper design, performance, and ease of querying.

• Expert in solving complex SQL problems and tuning Query Execution Plans / indexes for performance.

• Expert in designing data abstraction layers to avoid technical debt and improve future extensibility.

• Broad contract experience ranging from short to long term jobs, large to small corporations in several industries, government and international organizations, and IT departments.

• Collaborative work style. Every idea is improved with collaboration.

• SQL Server data security expert.

Design Theory Summary:

An elegant database design physical schema makes the data intuitively obvious and enables writing high performance set-based queries that respond well to indexing. This in turn creates short, tight transactions which improves concurrency and scalability while reducing the aggregate workload of the database. This flow from layer to layer becomes a methodology for designing, developing, and optimizing databases.