Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 186 of 212

174 C H A P T E R 8 | Improved Azure SQL Database us/documentation/articles/sql-database-elastic-jobs-service-installation/ and "Create and manage a SQL Database elastic database jobs using PowerShell" at us/documentation/articles/sql-database-elastic-jobs-powershell/. Distributing queries with elastic query An elastic query can execute a T-SQL query across multiple SQL Databases by using a single connection, without requiring those databases to coexist in a single elastic database pool. You can use elastic query with any Standard or Premium SQL Database, whether or not the database is in an elastic database pool. Elastic query is particularly useful for returning the combined results from multiple databases to reporting or data-integration tools. Because Azure transparently handles the distributed query processing, users and applications see only one database, using any driver compatible with SQL Database, as shown in Figure 8-9. Figure 8-9: Executing an elastic query. Note To use elastic query, you must create a database-scoped master key and credentials to connect to the shard map manager and the shards and then create an external data source and external tables. For more information, see "Getting started with cross-database queries (vertical partitioning)" at query-getting-started-vertical/ and "Getting Started with elastic queries for sharding (horizontal partitioning)" at query-getting-started/.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016