Professional Azure SQL Database Administration

DespitebeingthecloudversionofSQLServer,AzureSQLDatabasediffersinkeywayswhenitcomestomanagement,maintenance,andadministration.ThisbookshowsyouhowtoadministerAzureSQLdatabasetofullybenefitfromitswiderangeoffeaturesandfunctionality.ProfessionalAzureSQLDatabaseAdministrationbeginsbycoveringthearchitectureandexplainingthedifferencebetweenAzureSQLDatabaseandtheon-premiseSQLServertohelpyougetcomfortablewithAzureSQLdatabase.You’llperformcommontaskssuchasmigrating,backingup,andrestoringaSQLServerdatabasetoanAzuredatabase.Asyouprogress,you’llstudyhowyoucansavecostsandmanageandscalemultipleSQLDatabasesusingelasticpools.You’llalsoimplementadisasterrecoverysolutionusingstandardandactivegeo-replication.WhetheritislearningdifferenttechniquestomonitorandtuneanAzureSQLdatabaseorimprovingperformanceusingin-memorytechnology,thisbookwillenableyoutomakethemostoutofAzureSQLdatabasefeaturesandfunctionalityfordatamanagementsolutions.Bytheendofthisbook,you’llbewellversedwithkeyaspectsofanAzureSQLdatabaseinstance,suchasmigration,backuprestorations,performanceoptimization,highavailability,anddisasterrecovery.