Davidson / Moss Pro SQL Server Relational Database Design and Implementation

Fifth Auflage
ISBN: 978-1-4842-1973-7
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 793 Seiten

Reihe: Professional and Applied Computing

Pro SQL Server Relational Database Design and Implementation has long been the go-to book on database design for Microsoft SQL Server users. The book enters its fifth edition as a proven-successful melding of database design techniques with physical implementation advice written by a prominent member of the SQL Server community. The author is a frequent speaker at industry events, and is a longstanding Microsoft MVP.

• Covers the latest design-oriented features in SQL Server 2016
  
• Includes in-memory OLTP and column store indexing
  
• Applies SQL Server features in the context of sound relational design
  

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Davidson, Louis

Moss, Jessica

Inhaltsverzeichnis

1. The Fundamentals.- 2. Introduction to Requirements.- 3. The Language of Data Modeling.- 4. Conceptual and Logical Data Model Production.- 5. Normalization.- 6. Physical Model Implementation Case Study.- 7. Expanding Data Protection with Check Constraints and Triggers.- 8. Patterns and Anti-Patterns.- 9. Database Security and Security Patterns.- 10. Index Structures and Application.- 11. Matters of Concurrency.- 12. Reusable Standard Database Components.- 13. Architecting Your System.- 14. Reporting Design.- 15. Appendix: Scalar Datatype Reference.

Über Autor(innen)

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.
Jessica Moss is a well-known architect, speaker, author, and Microsoft "Most Valuable Professional" of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, Internet, health services, finance, and energy industries, and has authored technical content for multiple magazines, websites, and the book Microsoft SQL Server2008 Integration Services: Problem-Design-Solution. Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read more on her website.