Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 171 of 212

159 C H A P T E R 8 | Improved Azure SQL Database section, we explore the evolution of SQL Database, explain how the service is priced, and highlight the elements of SQL Database that provide high availability and disaster-recovery benefits. Reviewing the evolution of SQL Database The initial version of SQL Database offered many of the same benefits available in other Azure cloud- based services—elasticity, scalability, high availability, fast provisioning, and easy administration. However, as compared to an on-premises instance of SQL Server, this early version of SQL Database had only a subset of features. For example, only simple data types were supported, and the database size was limited to 5 GB, which limited the type of applications that could use SQL Database to applications,such as mobile applications and websites. Also, there was no support for database backups, although it was possible to make a database extract as an alternative. Although these aspects of SQL Database were challenges for enterprise-scale applications with complex data types and large data volumes, smaller-scale, new applications could be architected specifically to work well with SQL Databases's feature set. Furthermore, there were several benefits that database administrators and application developers could appreciate, such as the lower cost to deploy and maintain databases in the cloud, the use of established skills through the compatibility with existing management tools, and the elimination of administrative overhead required for on- premises hardware. To address concerns related to data protection in the cloud, Microsoft not only included many security features available in on-premises SQL Server in the first release of SQL Database, but also enforced industry-leading best practices to physically secure the Azure environment and eliminate threats in its data centers. Furthermore, Azure security compliance is validated by third-party audits and certifications to ensure conformance with international and industry standards. The security features introduced in the initial release, such as a server-side firewall restricting access to specific IP addresses, SQL authentication, and encrypted connections, continue to be a part of SQL Database, but even more features have been added recently to provide stricter and more granular levels of security, as we describe later in the "SQL Database security" section of this chapter. In addition to these security enhancements, SQL Database now has greater parity with on-premises SQL Server. This parity allows you to more easily port current on-premises applications to Azure and to better support enterprise and DevOps requirements in the cloud, thereby greatly expanding the number of potential use cases for SQL Database. Specifically, you can now take advantage of the following database features in the cloud: Parallel queries Table partitioning Online reindexing XML indexes CLR integration Change tracking for data changes Columnstore indexes T-SQL windowing functions Over 100 new DMVs

Articles in this issue

Archives of this issue

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