Leverage the features of Azure SQL database and become an expert in data management Key FeaturesExplore ways to create shards and elastic pools to scale Azure SQL databasesAutomate common management tasks with PowerShellImplement over 40 practical activities and exercises to reinforce your learningBook 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 learnUnderstand Azure SQL Database configuration and pricing optionsProvision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL DatabaseBack up and restore Azure SQL DatabaseSecure an Azure SQL databaseScale an Azure SQL databaseMonitor and tune an Azure SQL databaseImplement high availability and disaster recovery with Azure SQL DatabaseAutomate common management tasks with PowerShellDevelop a scalable cloud solution with Azure SQL DatabaseManage, maintain, and secure managed instancesWho 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.

Master data management by effectively utilizing the features of Azure SQL database. Key FeaturesLearn to automate common management tasks with PowerShell.Understand different methods to generate elastic pools and shards to scale Azure SQL databases.Learn to develop a scalable cloud solution through over 40 practical activities and exercises.Book Description Despite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management. The book begins by introducing you to the Azure SQL managed databases (Azure SQL Database and Azure SQL Managed Instance), explaining their architecture, and how they differ from an on-premises SQL server. You will then learn how to perform common tasks, such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you will study how you can save costs and manage and scale multiple SQL databases using elastic pools. You will also implement a disaster recovery solution using standard and active geo-replication. Finally, you will explore the monitoring and tuning of databases, the key features of databases, and the phenomenon of app modernization. By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learnUnderstanding Azure SQL database configuration and pricing optionsProvisioning a new SQL database or migrating an existing on-premises SQL Server database to an Azure SQL databaseBacking up and restoring an Azure SQL databaseSecuring and scaling an Azure SQL databaseMonitoring and tuning an Azure SQL databaseImplementing high availability and disaster recovery with an Azure SQL databaseManaging, maintaining, and securing managed instancesWho this book is for This book is designed to benefit database administrators, database developers, or application developers who are interested in developing new applications or migrating existing ones with Azure SQL database. 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.

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

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.

This book is ideal for IT professionals who have some experience with SQL Server or Database but are looking for a rich hands-on resource with guidance to explore each of the Azure SQL administrator concepts and the solutions the cloud provider offers.The book is primarily designed for Cloud DBAs (with ample knowledge of SQL server) who are new to Azure and want to have a solid start and get an in-depth glimpse on advanced topics that will help them to solve day-to-day issues plus effectively support the Azure databases. Administering Relational Databases on Microsoft Azure takes readers through a complete tour of understanding fundamental Azure concepts, Azure SQL administration, Azure Management tools, and techniques. This book will give an edge over to clear DP 300 exam. Increasingly, we continue to flood with information about the importance of the cloud. Cloud computing is everywhere, but not everyone knows exactly what it is and where to get started.We try to focus more on Azure SQL and give you the foundational understanding of what the cloud really is and tell you how some of these cloud technologies can work for you, and direct you to improve your knowledge and get certified with hassle-free learning. If you find it is for you, you will pick up useful tricks and tips for making a move to the cloud as seamless as possible.It is never too late to turn the corner from "On-premise DBA" to "Cloud DBA specialist". In most technical discussions, we see a vast gap in cloud adoption and the reality of absorption. There is always a need to learn the Next-Gen technology. In this book, you explore the importance of understanding and managing cloud databases and the skills you must build around the Cloud to face the cloud DBA certification. In addition, along the way, you will pick up great interesting insights, real-time scenarios and fundamentals, concepts of Cloud, cloud management tools, test cases, and several practice solutions.

Leverage your Oracle DBA skills on Microsoft SQL Server 2008 Microsoft SQL Server 2008 Administration for Oracle DBAs shows you how to use your experience as an Oracle DBA to get up to speed quickly on the Microsoft SQL Server platform. Authors with real-world expertise in both Oracle and SQL Server introduce you to fundamental concepts, such as SQL Server architecture and core administration, before guiding you through advanced techniques, including performance optimization, high availability and disaster recovery. Platform comparisons, on-the-job examples, and answers to questions raised by Oracle DBAs learning the SQL Server environment help build your skills. This practical guide shows you how to: Identify the components of the SQL Server platform Understand SQL Server architecture Install and configure SQL Server software and client components Define and manage database objects Implement and administer database security Monitor, identify, and resolve performance issues Design and implement high availability, system backup, and disaster recovery strategies Automate SQL Server using built-in scheduling and alerting capabilities Import and export data to and from SQL Server and other RDBMS platforms Upgrade existing SQL Server installations and migrate Oracle databases to SQL Server

An authoritative guide to extending SharePoint's power with cloud-based services If you want to be part of the next major shift in the IT industry, you'll want this book. Melding two of the hottest trends in the industry—the widespread popularity of the SharePoint collaboration platform and the rapid rise of cloud computing—this practical guide shows developers how to extend their SharePoint solutions with the cloud's almost limitless capabilities. See how to get started, discover smart ways to leverage cloud data and services through Azure, start incorporating Twitter or LinkedIn into your solutions, find the best ways to secure everything, and much more. Shows developers how to use Microsoft SharePoint 2010 to create scalable, cloud-based solutions Melds the hottest new trend in the industry—developing, hosting, managing, or storing code in the cloud—with what SharePoint developers need to know to weave these technologies into their solutions Provides developer patterns, real-world examples, and invaluable walkthroughs Topics include SQL Azure for data management and BI, building an Azure-based corporate tax service, connecting Linked In and SharePoint profile data, creating a filterable Twitter dashboard, leveraging Bing Maps Geo services, maintaining security, and more SharePoint developers, discover exciting new ways to extend SharePoint's functionality with this practical and content-rich guide.

A highly effective, integrated self-study system for the Microsoft Azure Fundamentals exam Prepare for the current version of the Microsoft Azure Fundamentals exam using the detailed information contained in this test preparation guide. Written by a cloud computing expert and experienced author, the book contains accurate practice questions, step-by-step exercises, and special elements that aid in learning and reinforce retention. Microsoft Certified Azure Fundamentals All-in-One Exam Guide (Exam AZ-900) features in-depth coverage of every topic on the challenging exam. You will explore core Azure services, security, compliance, and trust. Fulfilling the promise of the All-in-One series, the guide serves as both a test preparation tool and an on-the-job reference for risk and compliance professionals. •100% coverage of all objectives for the Microsoft Azure Fundamentals exam •Contains hands-on exercises and practical use cases for Microsoft Azure •Online content includes practice exam software with 120 questions

This text focuses on advanced topics and demonstrates the new features of the integrated development environment. Readers will learn the powerful and fascinating techniques without repetitive pedagogical concepts, and without feeling the burden of 'information overload'

The go-to guidebook for deploying Big Data solutions with Hadoop Today's enterprise architects need to understand how the Hadoop frameworks and APIs fit together, and how they can be integrated to deliver real-world solutions. This book is a practical, detailed guide to building and implementing those solutions, with code-level instruction in the popular Wrox tradition. It covers storing data with HDFS and Hbase, processing data with MapReduce, and automating data processing with Oozie. Hadoop security, running Hadoop with Amazon Web Services, best practices, and automating Hadoop processes in real time are also covered in depth. With in-depth code examples in Java and XML and the latest on recent additions to the Hadoop ecosystem, this complete resource also covers the use of APIs, exposing their inner workings and allowing architects and developers to better leverage and customize them. The ultimate guide for developers, designers, and architects who need to build and deploy Hadoop applications Covers storing and processing data with various technologies, automating data processing, Hadoop security, and delivering real-time solutions Includes detailed, real-world examples and code-level guidelines Explains when, why, and how to use these tools effectively Written by a team of Hadoop experts in the programmer-to-programmer Wrox style Professional Hadoop Solutions is the reference enterprise architects and developers need to maximize the power of Hadoop.