SQL Architecture Basics Joes 2 Pros  (English, Paperback, Morelan Rick A)

Published in the year 2012, SQL Architecture Basics Joes 2 Pros: Core Architecture Concepts is a book that provides its readers with detailed insight into the usage of SQL Servers.

Summary Of The Book

It is a known fact that as the size of an organization increases, their need for storing large amounts of data increases as well. This book, SQL Architecture Basics Joes 2 Pros: Core Architecture Concepts is a powerful guide written by one of the leading authorities in the field of databases, Rick Morelan. This book provides its readers with detailed information into the working of SQL server.

In total, there are 13 chapters in this book. The chapters include Full Text Indexing, Data Type Usage, Database File Structures, Partitioned Tables, Index Analysis, Creating Indexes, Special Data Type Options, Alering Partitioned Tables, Index Maintenance, Creating Indexes With Code, Special Index Types, and Spatial Data Type Options.

In this book, the readers are acquainted with a number of highly-advanced queries, and it also provides its readers with information regarding the background working of SQL server, on creating database objects, and running queries. This book aims at providing its readers with the kind of queries that may suit their requirements, in terms of efficiency, and speed. All in all, this book is a must-have for those who want to take their understanding of SQL to the next level.

About Rick A. Morelan

Rick A. Morelan is an author, and database expert.

Apart from this book, Morelan has written a number of other books on databases, and some of them include SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues (2011), SQL Queries 2012 Joes 2 Pros: The SQL Hands-On Tutorial For Beginners (Volume-1), SQL Queries 2012 Joes 2 Pros: Advanced Query Tools And Techniques For SQL Server 2012 ( Volume -3), and SQL Backup And Recovery Joes 2 Pros.

Morelan used to work as an Alaska Commercial fisherman, in the Bering Sea, in the year 1994. However, he later decided to step into the world of computers, and began taking lessons from the Catapulty Software Training Institute. In August 1995, Morelan was appointed by Microsoft, and worked with databases. He has over 10 years experience at Microsoft, and has more than 30 certifications from the organization, in the fields of .NET development, databases, applications, and networking.