Professional Azure SQL Database Administration

Discoverhowyoucanmigrateatraditionalon-premiseSQLserverdatabasetoacloud-basedsolutionwithMicrosoftAzure.Builtwithdatabaseadministratorsinmind,thisbookemulatesdifferentscenariosyoumightcomeacrosswhileworkingwithlarge,complexSQLdatabasemigrationsandprovidessolutionsforeffectivelymanagingthemigrateddatabases.KeyFeatures*Implementbackup,restore,andrecoveryofAzureSQLdatabases*CreateshardsandelasticpoolstoscaleAzureSQLdatabases*AutomatecommonmanagementtaskswithPowerShell*Implementover40practicalactivitiesandexercisesacross24topicstoreinforceyourlearningBookDescriptionAsthecloudversionofSQLServer,AzureSQLDatabasediffersinkeywayswhenitcomestomanagement,maintenance,andadministration.It’simportanttoknowhowtoadministerSQLDatabasetofullybenefitfromallofthefeaturesandfunctionalitythatitprovides.ThisbookaddressesimportantaspectsofanAzureSQLDatabaseinstancesuchasmigration,backuprestorations,pricingpolicies,security,scalability,monitoring,performanceoptimization,highavailability,anddisasterrecovery.Itisacompleteguidefordatabaseadministrators,andidealforthosewhoareplanningtomigratefromonpremiseSQLServerdatabasetoanAzureSQLServerdatabase.Whatyouwilllearn*Learnhowtoprovisionanewdatabaseormigrateanexistingon-premisesolution*Understandhowtobackup,restore,secure,andscaleyourownAzureSQLDatabase*Optimizetheperformancebymonitoringandtuningyourcloud-basedSQLinstance*ImplementhighavailabilityanddisasterrecoveryprocedureswithSQLDatabase*DeveloparoadmapforyourownscalablecloudsolutionwithAzureSQLDatabaseWhothisbookisforThisbookisidealfordatabaseadministrators,databasedevelopers,orapplicationdeveloperswhoareinterestedindevelopingormigratingexistingapplicationswithAzureSQLDatabase.Priorexperienceofworkingwithanon-premiseSQLServerdeploymentandbriefknowledgeofPowerShellandC#arerecommendedprerequisites.