Introduction to SQL Database

SQL database is a cloud relational database service based on Microsoft's most advanced Sql server engine, with mission-critical capabilities. SQL database provides predictable performance, scalability without downtime, business continuity and data protection, all of which require little or no management. Instead of spending a lot of time managing infrastructure such as virtual machines, you can focus on rapid application development and faster time-to-market for your products. Because it is based on the Sql server engine, the  sql database supports existing sql server tools, libraries and api&nbsp, making it easier for you to move and extend your app to the cloud.    tuning performance does not stop this feature in SQL database Basic, Standard, featured are available. Each service provides different levels of performance and functionality to provide different heavyweight support for database workloads. You can first deploy your pre-application on a small database for one months and then just a few dollars, and then when your app slowly gets bigger, you can upgrade the SQL database directly or through code without downtime.   For many businesses and applications, the ability to create databases and single database performance is up or down, especially if the usage patterns are relatively predictable. But if you have unpredictable usage patterns, it's more difficult to manage costs and your business model.   Using SQL database elastic pool To solve this problem, this concept is simple. You assign performance to a pool and pay for the collective performance of the pool rather than the performance of a single database. You do not need to manually tune database performance or drop the elastic database in the pool to automatically scale to suit your needs. The elastic database consumes resources but does not exceed the pool limit, so your costs are still predictable, even if the database usage is unpredictable.   Either way, single or elastic can be used, not the choice of one cannot choose the second kind. You can mix a single database with an elastic database pool, and even you can change the service level of a single database to be an innovative design for elastic pools. In addition, you can mix and match Azure's SQL database services to meet your customization needs, increase cost and resource efficiency, and open new business opportunities.   However, how can I compare database and database pool dependencies? The answer lies in the difference between a database transaction unit (DTU) Single Database and elastic DTU (EDTU) elastic database and database. Azure has an industry-leading 99.99% availability Service level agreement (SLA), and Microsoft manages the global network of Data Center power (BTW, in China is by century connected operation, because you understand), helps keep your program running in a healthy and 24x7. You can use built-in data protection, fault tolerance, and data protection in every SQL database, or you'll need toDesign, purchase, build and manage yourself. Even so, depending on your business needs, you may need an additional layer of protection to ensure that your application and your business can recover quickly in the event of a disaster, error, or other unforeseen accident. In SQL database, each service tier provides a different menu feature that you can use to start and keep it that way. You can use a little time to recover to a database to an earlier state, the earliest is 35 days. In addition, if there is a problem with the data center where your data resides, you can switch to a copy of the database in a different region. Or you can use a copy to upgrade or migrate to a different region.  sql server has a traditional, solid data security, SQL database maintenance features, restricted permissions, protected data, and helps you monitor activities.

Introduction to SQL Database