Learn SQL Database Programming: Query and manipulate databases from popular relational database servers using SQLJosephine Bush
Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition
- Kirjailija
- Kustantaja
- Kieli
- Englanti
- Format
- Kategoria
Tietokirjallisuus
Leverage the features of Azure SQL database and become an expert in data management
Key Features
• Explore ways to create shards and elastic pools to scale Azure SQL databases
•
• Automate common management tasks with PowerShell
•
• Implement over 40 practical activities and exercises to reinforce your learning
Book Description
Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality.
Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You'll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you'll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You'll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions.
By the end of this book, you'll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery.
What you will learn
• Understand Azure SQL Database configuration and pricing options
•
• Provision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL Database
•
• Back up and restore Azure SQL Database
•
• Secure an Azure SQL database
•
• Scale an Azure SQL database
•
• Monitor and tune an Azure SQL database
•
• Implement high availability and disaster recovery with Azure SQL Database
•
• Automate common management tasks with PowerShell
•
• Develop a scalable cloud solution with Azure SQL Database
•
• Manage, maintain, and secure managed instances
Who this book is for
If you're a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.
© 2019 Packt Publishing (E-kirja): 9781789804188
Julkaisupäivä
E-kirja: 19. heinäkuuta 2019
Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition
- Kirjailija
- Kustantaja
- Kieli
- Englanti
- Format
- Kategoria
Tietokirjallisuus
Leverage the features of Azure SQL database and become an expert in data management
Key Features
• Explore ways to create shards and elastic pools to scale Azure SQL databases
•
• Automate common management tasks with PowerShell
•
• Implement over 40 practical activities and exercises to reinforce your learning
Book Description
Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality.
Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You'll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you'll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You'll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions.
By the end of this book, you'll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery.
What you will learn
• Understand Azure SQL Database configuration and pricing options
•
• Provision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL Database
•
• Back up and restore Azure SQL Database
•
• Secure an Azure SQL database
•
• Scale an Azure SQL database
•
• Monitor and tune an Azure SQL database
•
• Implement high availability and disaster recovery with Azure SQL Database
•
• Automate common management tasks with PowerShell
•
• Develop a scalable cloud solution with Azure SQL Database
•
• Manage, maintain, and secure managed instances
Who this book is for
If you're a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.
© 2019 Packt Publishing (E-kirja): 9781789804188
Julkaisupäivä
E-kirja: 19. heinäkuuta 2019
Saattaisit pitää myös näistä
- Introducing Microsoft SQL Server 2019 : Reliability, scalability and security both on premises and in the cloud: Reliability, scalability, and security both on premises and in the cloudMitchell Pearson
- How To Learn Microsoft SQL Server Quickly!Andrei Besedin
- Python: Tips and Tricks to Programming Code with PythonCharlie Masterson
- Mastering SQL Server 2017: Build smart and efficient database applications for your organization with SQL Server 2017Dejan Sarka
- Hands-On Data Science with SQL Server 2017: Perform end-to-end data analysis to gain efficient data insightMarek Chmel
- SQL Programming: The Ultimate Guide with Exercises, Tips and Tricks To Learn SQLDamon Parker
- Deep Learning With Python Illustrated Guide For Beginners & Intermediates: The Future Is Here!William Sullivan
- Professional Azure SQL Database Administration: Equip yourself with the skills you need to manage and maintain your SQL databases on the Microsoft cloudAhmad Osama
- Mastering C++ ProgrammingJeganathan Swaminathan
Kuuntele missä ja milloin haluat
Astu tarinoiden maailmaan
- Pohjoismaiden suosituin ääni- ja e-kirjapalvelu
- Uppoudu suureen valikoimaan äänikirjoja, e-kirjoja ja podcasteja
- Storytel Original -sisältöjä yksinoikeudella
- Ei sitoutumisaikaa
Kirja-arviot
Kooste arvioista
Ei arvosteluja vielä
Lataa sovellus niin voit osallistua keskusteluun ja kirjoittaa oman arviosi.
Hyödyllisiä linkkejä
Kieli ja alue
Suomi
Suomi
