Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Professional Azure SQL Database Administration
  • Table Of Contents Toc
  • Feedback & Rating feedback
Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

By : Ahmad Osama
5 (2)
close
close
Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

5 (2)
By: Ahmad Osama

Overview of this book

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.
Table of Contents (11 chapters)
close
close
Free Chapter
1
1. Microsoft Azure SQL Database Primer
4
4. Restoring an Azure SQL Database
10
Index

Installation and Setup

Before you start with this book, we'll sign up to Azure. You will find the steps to sign up here:

Sign up for a Free Azure Account

  • Open the following link in a browser: https://azure.microsoft.com/en-us/free/
  • Select Start Free. In the sign-up page, login using your Microsoft account and follow the steps to create a free Azure account.
  • If you don't have a Microsoft account, you can create a new one by selecting the Create one!
  • An Azure account requires you to provide credit card details. However, no money is charged even if you have exhausted your free credit or free month. The resources you created will be stopped and can only be started once you sign-up for a paid account.

Install SQL Server Management Studio

Installing Microsoft PowerShell 5.1

  1. Open the following URL in the browser to get to open the download page - https://www.microsoft.com/en-us/download/details.aspx?id=54616
  2. Click on the download button and select Win8.1AndW2K12R2-KB3191564-x64.msu. Click on next to download and the install the Windows Management Framework 5.1 to upgrade to PowerShell 5.1

Installing Microsoft Azure PowerShell

  1. Install the Web Platform installer
    1. Open the following link in a browser https://www.microsoft.com/web/downloads/platform.aspx
    2. Scroll to the end and select x64 under Download WebPI 5.0 to download the web platform installer.
    3. Double click on the downloaded exe file and follow the steps to install Web PI 5.0
  2. Open Web PI and type Microsoft Azure PowerShell in the search box. Follow the steps to download the latest version.

Installing Microsoft RML Utilities

  1. Open the following link in a browser - https://www.microsoft.com/en-in/download/details.aspx?id=4511
  2. Click on download to download the installer. Click on the downloaded file and follow the instructions to install RML Utilities.

Installing Visual Studio Community Edition

  1. Visual Studio command prompt is required to generate self-signed certificates. As there's no easy way to install only the Visual Studio command prompt it's advised to install the Visual Studio 2013 or above community edition.
  2. Open the following link in a browser - https://www.visualstudio.com/downloads/
  3. Download and install the Visual Studio 2017 community edition and follow the instructions to install it.
  4. You may get a different version to download. The latest Visual Studio version available at the time of the book is 2017.

Get in touch

Feedback from our readers is always welcome.

General feedback: Email and mention the book title in the subject of your message. If you have questions about any aspect of this book, please email us at .

Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book, we would be grateful if you would report this to us. Please visit www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.

Piracy: If you come across any illegal copies of our works in any form on the Internet, we would be grateful if you would provide us with the location address or website name. Please contact us at with a link to the material.

If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit authors.packtpub.com.

Reviews

Please leave a review. Once you have read and used this book, why not leave a review on the site that you purchased it from? Potential readers can then see and use your unbiased opinion to make purchase decisions, we at Packt can understand what you think about our products, and our authors can see your feedback on their book. Thank you!

For more information about Packt, please visit packtpub.com.

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY