Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Professional Azure SQL Database Administration: Equip yourself with the skills you need to manage and maintain your SQL databases on the Microsoft cloud


Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases.

Key Features

  • Implement backup, restore, and recovery of Azure SQL databases
  • Create shards and elastic pools to scale Azure SQL databases
  • Automate common management tasks with PowerShell
  • Implement over 40 practical activities and exercises across 24 topics to reinforce your learning

Book Description

As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It’s important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database.

What you will learn

  • Learn how to provision a new database or migrate an existing on-premise solution
  • Understand how to backup, restore, secure, and scale your own Azure SQL Database
  • Optimize the performance by monitoring and tuning your cloud-based SQL instance
  • Implement high availability and disaster recovery procedures with SQL Database
  • Develop a roadmap for your own scalable cloud solution with Azure SQL Database

Who this book is for

This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.

Table of Contents

  1. Microsoft Azure SQL Database Primer
  2. Migrating a SQL Server Database to an Azure SQL Database
  3. Backing Up the Azure SQL Database
  4. Restoring an Azure SQL Database
  5. Securing an Azure SQL Database
  6. Scaling Out Azure SQL Database
  7. Elastic Pools
  8. High Availability and Disaster Recovery
  9. Monitoring and Tuning Azure SQL Database
(HTML tags aren't allowed.)

How to Create the Next Facebook: Seeing Your Startup Through, from Idea to IPO
How to Create the Next Facebook: Seeing Your Startup Through, from Idea to IPO

In just under a decade, Facebook has gone from a Harvard prodigy's dorm-room experiment to an essential part of the social life of hundreds of millions of children, teens, and adults across the globe. It's no surprise, then, that the company has been the subject of countless magazine articles, books, and even movies. But despite the...

Spine Surgery Basics
Spine Surgery Basics

Spine surgery has increasingly become a surgical field of its own, with a distinct body of knowledge. This easy-to-use book, written by acknowledged experts, is designed to meet the practical needs of the novice and the busy resident by providing essential information on spine pathology, diagnostic evaluation, surgical procedures, and other...

Accounting: Concepts and Applications
Accounting: Concepts and Applications

No matter what your career plans or future goals, ACCOUNTING: CONCEPTS AND APPLICATIONS, 10e helps you develop a solid understanding of accounting and its importance in business today that will put you well ahead of the competition. Organized around business activities, the text balances an introduction to accounting procedures with an...

Master Humphrey's Clock
Master Humphrey's Clock
THE reader must not expect to know where I live. At present, it is true, my abode may be a question of little or no import to anybody; but if I should carry my readers with me, as I hope to do, and there should spring up between them and me feelings of homely affection and regard attaching something of interest to matters ever so slightly connected...
RESTful Java Patterns and Best Practices
RESTful Java Patterns and Best Practices

Learn best practices to efficiently build scalable, reliable, and maintainable high performance RESTful services

About This Book

  • Learn how to build RESTful services with JAX-RS 2.0
  • Efficiently use the techniques outlined to build reliable and highly available applications based on...
Python Testing: Beginner's Guide
Python Testing: Beginner's Guide

Automated testing moves much of the labor of testing off the developer and makes it easier as well as quicker to find bugs and fix them. Automated tests run faster, increase test coverage, and lower costs. However, testing is neither an easy process nor remotely exciting for most developers. But with the right techniques and tools, testing can...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy