One of the most popular databases worldwide is Microsoft’s SQL Server. Now Microsoft has introduced their MPP data warehouse system, designed for the cloud, called the Microsoft Azure SQL Data Warehouse. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. This book details the architecture of the Azure SQL Data Warehouse and the SQL commands available. This book is perfect for anyone who works with the Microsoft Azure SQL Data Warehouse. This book educates readers on how to create tables and indexes, how the data is distributed, and how the system process the data. Plus, it is followed up with over 700 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying the system. The Authors of Tera-Tom Coffing, who has written over 70 successful books and Todd Wilson, CTO of Coffing Data Warehousing bring a combination of minds together made up of experience and real business world knowledge.
Sobre o autor
Todd Wilson is the Chief Technology Officer of Coffing Data Warehousing. As CTO, Todd has overseen the development of Coffing DW’s premiere data analytics tool, The Nexus Query Chameleon. Under Todd’s leadership, the Nexus has expanded to support data sources from all spectrums of data warehousing such as Kognitio (in-memory analytics), HP Vertica (columnar data), Hadoop (including such “Big Data” companies as Cloudera and Hortonworks), cloud service data sources (Amazon’s Redshift), as well as traditional data sources such as Oracle, Teradata, SQL Server, Greenplum, and DB2.
An experienced .NET developer, Todd has developed data replication tools, data movement tools, data visualization tools, database management tools, DDL conversion tools and is currently overseeing the development of the Nexus Logical Model Loader. As a technical consultant, he has worked with multiple Fortune 500 companies in fields such as telecommunication, PC manufacturing, and health care. Todd is a Teradata Certified Master and a graduate of Pepperdine University.