About the Authors |
|
ix | |
About the Technical Reviewers |
|
xi | |
Foreword |
|
xiii | |
Introduction |
|
xvii | |
|
Chapter 1 Working with Azure Database Services Platform |
|
|
1 | (82) |
|
Understanding the Service |
|
|
1 | (7) |
|
|
3 | (2) |
|
|
5 | (3) |
|
|
8 | (12) |
|
|
9 | (4) |
|
|
13 | (7) |
|
Migrating an Existing Database |
|
|
20 | (5) |
|
|
20 | (2) |
|
|
22 | (3) |
|
|
25 | (23) |
|
|
26 | (3) |
|
Split between Read/Write Applications |
|
|
29 | (5) |
|
|
34 | (3) |
|
|
37 | (2) |
|
|
39 | (9) |
|
|
48 | (8) |
|
Managing Elasticity at Runtime |
|
|
51 | (2) |
|
Pooling Different DBs Under the Same Price Cap |
|
|
53 | (2) |
|
|
55 | (1) |
|
|
56 | (22) |
|
|
56 | (7) |
|
|
63 | (2) |
|
|
65 | (13) |
|
|
78 | (4) |
|
|
79 | (2) |
|
|
81 | (1) |
|
|
82 | (1) |
|
Chapter 2 Working with SQL Server on Hybrid Cloud and Azure IaaS |
|
|
83 | (86) |
|
Database Server Execution Options On Azure |
|
|
84 | (1) |
|
A Quick Overview of SQL Server 2017 |
|
|
85 | (9) |
|
Installation of SQL Server 2017 on Linux and Docker |
|
|
87 | (4) |
|
SQL Server Operations Studio |
|
|
91 | (3) |
|
|
94 | (38) |
|
|
95 | (9) |
|
|
104 | (22) |
|
SQL Server Stretched Databases |
|
|
126 | (6) |
|
Migrate databases to Azure laaS |
|
|
132 | (5) |
|
Migrate a Database Using the Data-Tier Application Framework |
|
|
134 | (3) |
|
Run SQL Server on Microsoft Azure Virtual Machines |
|
|
137 | (15) |
|
Why Choose SQL Server on Azure Virtual Machines |
|
|
137 | (2) |
|
Azure Virtual Machines Sizes and Preferred Choice for SQL Server |
|
|
139 | (6) |
|
Embedded Features Available and Useful for SQL Server |
|
|
145 | (3) |
|
Design for Storage on SQL Server in Azure Virtual Machines |
|
|
148 | (4) |
|
Considerations on High Availability and Disaster Recovery Options with SQL Server on Hybrid Cloud and Azure IaaS |
|
|
152 | (15) |
|
Hybrid Cloud HA/DR Options |
|
|
153 | (4) |
|
|
157 | (10) |
|
|
167 | (2) |
|
Chapter 3 Working with NoSQL Alternatives |
|
|
169 | (94) |
|
|
169 | (6) |
|
|
172 | (1) |
|
|
173 | (2) |
|
NoSQL alternatives in Microsoft Azure |
|
|
175 | (1) |
|
Using Azure Storage Blobs |
|
|
175 | (26) |
|
Understanding Containers and Access Levels |
|
|
176 | (3) |
|
Understanding Redundancy and Performance |
|
|
179 | (13) |
|
Understanding Concurrency |
|
|
192 | (4) |
|
Understanding Access and Security |
|
|
196 | (5) |
|
Using Azure Storage Tables |
|
|
201 | (15) |
|
Planning and Using Table Storage |
|
|
202 | (6) |
|
|
208 | (7) |
|
|
215 | (1) |
|
|
216 | (24) |
|
Justifying the Caching Scenario |
|
|
216 | (7) |
|
|
223 | (10) |
|
|
233 | (7) |
|
|
240 | (21) |
|
Using SQL to Implement Search |
|
|
242 | (3) |
|
Understanding How to Start with Azure Search |
|
|
245 | (3) |
|
|
248 | (6) |
|
Implementing Azure Search |
|
|
254 | (7) |
|
|
261 | (2) |
|
Chapter 4 Orchestrate Data with Azure Data Factory |
|
|
263 | (64) |
|
Azure Data Factory Introduction |
|
|
263 | (9) |
|
Main Advantages of using Azure Data Factory |
|
|
265 | (1) |
|
|
266 | (6) |
|
Azure Data Factory Administration |
|
|
272 | (1) |
|
Designing Azure Data Factory Solutions |
|
|
272 | (44) |
|
Exploring Azure Data Factory Features using Copy Data |
|
|
273 | (15) |
|
Anatomy of Azure Data Factory JSON Scripts |
|
|
288 | (9) |
|
Azure Data Factory Tools for Visual Studio |
|
|
297 | (4) |
|
Working with Data Transformation Activities |
|
|
301 | (13) |
|
Microsoft Data Management Gateway |
|
|
314 | (2) |
|
Considerations of Performance, Scalability and Costs |
|
|
316 | (6) |
|
|
317 | (4) |
|
|
321 | (1) |
|
Azure Data Factory v2 (Preview) |
|
|
322 | (3) |
|
Azure Data Factory v2 Key Concepts |
|
|
322 | (3) |
|
|
325 | (2) |
|
Chapter 5 Azure Data Lake Store and Azure Data Lake Analytics |
|
|
327 | (66) |
|
How Azure Data Lake Store and Analytics were Born |
|
|
329 | (1) |
|
|
330 | (33) |
|
|
330 | (2) |
|
Hadoop Distributed File System |
|
|
332 | (1) |
|
Create an Azure Data Lake Store |
|
|
333 | (3) |
|
Common Operations on Files in Azure Data Lake Store |
|
|
336 | (5) |
|
Copy Data to Azure Data Lake Store |
|
|
341 | (20) |
|
Considerations on Azure Data Lake Store Performance |
|
|
361 | (2) |
|
Azure Data Lake Analytics |
|
|
363 | (28) |
|
|
363 | (1) |
|
|
364 | (2) |
|
Tools for Managing ADLA and Authoring U-SQL Scripts |
|
|
366 | (5) |
|
|
371 | (20) |
|
|
391 | (1) |
|
|
392 | (1) |
|
Chapter 6 Working with In-Transit Data and Analytics |
|
|
393 | (34) |
|
Understanding the Need for Messaging |
|
|
394 | (24) |
|
Use Cases of Uni-Directional Messaging |
|
|
396 | (3) |
|
|
399 | (10) |
|
|
409 | (9) |
|
Understanding Real-Time Analytics |
|
|
418 | (7) |
|
Understanding Stream Analytics |
|
|
419 | (3) |
|
Understanding AppInsights |
|
|
422 | (3) |
|
|
425 | (2) |
Index |
|
427 | |