Microsoft Azure Essentials Fundamentals of Azure Second Edition e-optimized 5x11 pdf

Administration  
One of the attractive features of SQL Database is the near-zero maintenance it provides. Microsoft 
handles all patching, server configuration, load balancing, and database platform upgrades 
automatically. Additionally, SQL Database handles management of system tables and filegroups 
automatically. You are required to perform common administrative tasks such as managing logical 
aspects of the database, including logins, tuning indexes, and query optimization. 
When using SQL Database, you can use the same tools, programming languages, and frameworks you 
are accustomed to using with SQL Server. SQL Database and SQL Server are similar in many ways, 
although not every SQL Server feature is available in SQL Database (see the section “Comparing SQL 
Database with SQL Server in Azure Virtual Machines” later in this chapter). However, the two do share 
one very important feature: both use TDS as the client protocol. This allows tools such as SQL Server 
Management Studio (SSMS) to connect to SQL Database.