Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 185 of 212

173 C H A P T E R 8 | Improved Azure SQL Database Figure 8-8: Elastic database pool settings in Azure Management Portal. Note You can also configure an elastic database pool by using PowerShell or REST APIs. To learn more, see "SQL Database elastic database pool reference" at us/documentation/articles/sql-database-elastic-pool-reference/. Using elastic database jobs Normally when you need to execute a T-SQL statement to perform an administrative task for multiple SQL Databases, you must log in to each database separately to execute the script. However, after you add databases to an elastic pool, you can execute that same script across all databases in the same elastic pool, in parallel and with built-in retry logic. You can use elastic database jobs to collect usage metrics from all databases, update reference data across databases, or implement schema changes, to name a few. To get started, navigate to the elastic database pool shard in the Azure Management Portal. You must click the Preview Terms link to accept the terms and install the following Azure components: Cloud Service, SQL Database, Service Bus, and Storage. Then click Job Credentials to supply a user name and password that Azure uses to log in to a new SQL Database, known as the control database, used for storing metadata about the elastic database jobs. Once the components are installed, you can click Create Job at the top of the elastic database pool shard, supply the credentials for the control database, provide a name for the job, type in credentials to connect to the target database (with permissions to execute the script), and paste or type in the T-SQL script. After you click Save, you can click Run to execute the script. The elastic database pool shard includes a Manage Jobs button to open a new shard in which you can see whether a job is running or has completed or failed. If you click a failed job, you can see its execution log. Note Alternatively, you can use PowerShell APIs to create and manage jobs. More information is available in "Installing Elastic Database jobs overview" at

Articles in this issue

Links on this page

Archives of this issue

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