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
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
Lock 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.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Professional Azure SQL Database Administration
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

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

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon