Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 190 of 212

178 C H A P T E R 9 | Introducing Azure SQL Data Warehouse provide a database name, set the performance level (which we describe in more detail in the "Scalability" section of this chapter), and choose the subscription, resource group, and server in which to host the data warehouse. You must also select one of the following options as a source: Blank database When you select this option, your database is empty and ready for you to create tables and other database objects. You can use an existing server in Azure or create a new one if you prefer. This server must be a V12 server. Sample This option creates a sample database on the AdventureWorksDW so that you can explore the features of SQL Data Warehouse before you build your own. Backup You can use this option to create a new database from an existing SQL Data Warehouse backup. Figure 9-2: Creating a new SQL Data Warehouse. Note After you create a SQL Data Warehouse, you cannot use SQL Server Management Studio to interact with it. Instead, use Microsoft SQL Server Data Tools 2015 (SSDT), which you can download from In SSDT, open SQL Server Object Explorer from the View menu, click the Add SQL Server button, type in the name of the server hosting the SQL Data Warehouse, change the authentication to SQL Server Authentication, provide the server administrator's credentials, select your database, and click Connect. Security SQL Data Warehouse has a multilevel security model to support enterprise usage. The first layer of SQL Data Warehouse security is at the connection layer. Like SQL Database, you select IP addresses to allow connections to the data warehouse; a connection that is not listed is blocked from access. Currently, SQL Data Warehouse supports SQL authentication only. Therefore, you enable user and application access by creating a SQL Server login with a strong password and a database user. You use database roles and permissions to allow access to data, exactly as you do in SQL Server.

Articles in this issue

Links on this page

Archives of this issue

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