Loading...

SQL Server Big Data Clusters by Benjamin Weissman & Enrico van de Laar

SQL Server Big Data Clusters by Benjamin Weissman & Enrico van de Laar

Author:Benjamin Weissman & Enrico van de Laar
Language: eng
Format: epub
ISBN: 9781484251102
Publisher: Apress


Listing 5-19Store data from CSV in temp tables instead of direct queries

This improves performance tremendously without wasting too many system resources as the large dataset stays within the CSV.

One of the biggest challenges in such an environment is finding a good trade-off between data redundancy and performance.

Accessing Data in an Azure Blob Storage

If you are storing data in an Azure Blob Storage, there is no need (apart from maybe network latency) to copy that data into your SqlStoragePool. You can also access a Blob Storage by defining it as an external data source (Listing 5-20).CREATE EXTERNAL DATA SOURCE AzureStorage with (

TYPE = HADOOP,

LOCATION ='wasbs://<blob_container_name>@<azure_storage_account_name>.blob.core.windows.net',

CREDENTIAL = AzureStorageCredential

);



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Categories
Macs PCs
Popular ebooks
But How Do It Know? by J. Clark Scott(1123)
Arduino Project Handbook, Volume 2: 25 Simple Electronics Projects for Beginners by Geddes Mark(1101)
31 Days Before Your CompTIA A+ Exams (Shanette Luellen's Library) by Benjamin Patrick Conry(1047)
Networking A Beginner's Guide by Bruce Hallberg(1047)
Hack and HHVM by Owen Yamauchi(1031)
Fusion 360 for Makers by Lydia Sloan Cline(997)
Computers For Seniors For Dummies by Nancy C. Muir(953)
PrestaShop Recipes by Arnaldo Pérez Castaño(894)
Raspberry Pi Electronics Projects for the Evil Genius (Tab) by Norris Donald & Norris Donald(799)
Getting Started with Soldering: A Hands-On Guide to Making Electrical and Mechanical Connections by Vinck Marc de(798)
The Internet of Things (The MIT Press Essential Knowledge series) by Greengard Samuel(789)
Healthcare Information Security and Privacy (All-In-One) by Sean Murphy(776)
Getting Started with the micro:bit by Wolfram Donat(763)
Raspberry Pi Beginners Guide: Ultimate Guide For Rasberry Pi, User guide To Get The Most Out Of Your Investment, Hacking, Programming, Python, Best Hardware, Beginners Guide To Rasberry Pi by Steven Giles(715)
Building Evolutionary Architectures by Neal Ford(712)
Mobile Computing Deployment and Management by Robert J. Bartz(705)
Arduino Project Handbook, Volume 2 by Mark Geddes(699)
Home Robotics by Daniel Knox(699)
Mastering Docker - Second Edition by McKendrick Russ & Gallagher Scott(683)
Shaping the Fourth Industrial Revolution by Klaus Schwab & Nicholas Davis & Satya Nadella(658)