Professional Azure SQL Database Administration Equip Yourself with the Skills You Need to Manage and Maintain Your SQL Databases on the Microsoft Cloud
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 import...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Birmingham
Packt Publishing, Limited
2018
Packt Publishing Limited Packt Publishing |
| Ausgabe: | 1 |
| Schlagworte: | |
| ISBN: | 9781789538854, 1789538858 |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Abstract | 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. |
|---|---|
| AbstractList | 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 migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. 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. |
| Author | Osama, Ahmad |
| Author_xml | – sequence: 1 fullname: Osama, Ahmad |
| BookMark | eNplj8tLAzEQxiM-0NYeve9NPLTmuZs91lofUFBRvC7TZKK1240mW4v-9QYrFXFgmBm-H9_wdchO4xsk5IjRAU11WhaaFbpUQuVFuUU6m4Nuk95G1FrJvSRSqTVlnKp90ovxJRmI1DzXB2RwG7zDGGe-gTobfi4DZvd3k-wcWphCxGxoF7NmFtsAbWIOya6DOmLvZ3bJ48X4YXTVn9xcXo-Gkz6I9K3sW7CSOaqVoUZL4XjOtXNMF4wZS1GyEpFLY6YIsrQKcmqFcpwCZzqX1IguOVkbQ5zjKj77uo3Ve41T7-ex-hP_l11B3WKw-BSWH2mpFhDMP_Z4zb4G_7bE2FbflgablLCuxmcjJbWiIhdf1odmOw |
| ContentType | eBook |
| DEWEY | 005.7585 |
| DOI | 10.0000/9781789535679 |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| EISBN | 1789535670 9781789535679 |
| Edition | 1 |
| ExternalDocumentID | 9781789535679 EBC5485036 |
| GroupedDBID | -VX 38. AABBV AAZEP ABARN ABCYV ABMRC ACBYE ACLGV ADVEM AEIUR AERYV AHWGJ AJFER ALMA_UNASSIGNED_HOLDINGS AVGCG AZZ BBABE CZZ DUGUG EBSCA GEOUK IHRAH J-X OHILO OODEK PASLL QD8 ABQPQ ACIWJ AFOJC ECOWB XI1 YSPEL |
| ID | FETCH-LOGICAL-a31049-dad41f085c0c843f2628ff18711cd0e419ee24ccbea49d5a60d35f20a218640c3 |
| ISBN | 9781789538854 1789538858 |
| IngestDate | Fri Nov 08 05:29:09 EST 2024 Fri Nov 21 22:13:39 EST 2025 Wed Dec 10 12:11:09 EST 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCallNum_Ident | QA76.9.C55 .O836 2018 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a31049-dad41f085c0c843f2628ff18711cd0e419ee24ccbea49d5a60d35f20a218640c3 |
| OCLC | 1048801205 |
| PQID | EBC5485036 |
| PageCount | 398 |
| ParticipantIDs | askewsholts_vlebooks_9781789535679 walterdegruyter_marc_9781789535679 proquest_ebookcentral_EBC5485036 |
| PublicationCentury | 2000 |
| PublicationDate | 2018 [2018] 2018-07-31 |
| PublicationDateYYYYMMDD | 2018-01-01 2018-07-31 |
| PublicationDate_xml | – year: 2018 text: 2018 |
| PublicationDecade | 2010 |
| PublicationPlace | Birmingham |
| PublicationPlace_xml | – name: Birmingham – name: Birmingham, UK |
| PublicationYear | 2018 |
| Publisher | Packt Publishing, Limited Packt Publishing Limited Packt Publishing |
| Publisher_xml | – name: Packt Publishing, Limited – name: Packt Publishing Limited – name: Packt Publishing |
| RestrictionsOnAccess | restricted access |
| SSID | ssj0003000268 |
| Score | 2.0666778 |
| Snippet | 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... |
| SourceID | askewsholts walterdegruyter proquest |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Cloud computing COMPUTERS / Databases / Servers COMPUTERS / Networking / General COMPUTERS / System Administration / General Database management Microsoft Azure (Computing platform) SQL server |
| Subtitle | Equip Yourself with the Skills You Need to Manage and Maintain Your SQL Databases on the Microsoft Cloud |
| TableOfContents | Activity: Perform Back-ups -- Summary -- Restoring an Azure SQL Database -- Restore Types -- Point-In-Time Restore -- Long-Term Database Restore -- Restoring Deleted Databases -- Geo-Restore Database -- Importing a Database -- Activity: Perform PITR -- Activity: Perform Geo-Restore -- Summary -- Securing an Azure SQL Database -- Access Control -- Firewall Rules -- Managing the Server-Level Firewall Rules using the Azure Portal -- Managing the Server-Level Firewall Rules using Transact-SQL -- Managing Database-Level Firewall Rules using Transact-SQL -- Authentication -- SQL Authentication -- Azure Active Directory Authentication -- Using Active Directory - Password to Authenticate to an Azure SQL Database -- Azure SQL Database Authentication Structure -- Azure SQL Database Authentication Considerations -- Authorization -- Creating Contained Database Users for Azure AD Authentication -- Groups and Roles -- Row-Level Security -- Dynamic Data Masking -- Proactive Security -- Auditing -- Configure Auditing for Azure SQL Server -- Threat Detection -- Configure Threat Detection for Azure SQL Server -- Activity: Implement Row-Level Security -- Activity: Implement Dynamic Data Masking -- Summary -- Scaling Out Azure SQL Database -- Vertical Scaling -- Scale Up or Scale Down Service Tiers -- Using T-SQL to Change the Service Tier -- Vertical Partitioning -- Horizontal Scaling -- Shard Map Manager -- Data Dependent Routing -- Multi-Tenant Data Models -- Single Tenant (database-per-tenant) -- Shared Database - Sharded -- Activity: Creating Alerts -- Activity: Creating Shards -- Activity: Split Data between Shard -- Activity: Using Elastic Queries -- Summary -- Elastic Pools -- Introducing Elastic Pools -- When Should You Consider Elastic Pools? -- Sizing an Elastic Pool -- Comparing the Pricing -- Sizing Best Practices Create an Elastic Pool and Add Toystore Store Shards to the Elastic Pool -- Elastic Jobs -- Use Cases -- Architecture -- Elastic Job Workflow -- Create an Elastic Job using the Azure Portal -- Activity: Exploring Elastic Pools -- Summary -- High Availability and Disaster Recovery -- High Availability -- Disaster Recovery -- Standard Geo-Replication -- Database Failover -- Active Geo-Replication -- Database Failover -- Synchronous Replication -- Auto-Failover Groups -- Auto-Failover Group Terms -- Configuring Active Geo-Replication and Performing a Manual Failover -- Configuring the Auto-Failover Group -- Activity: Configure Active Geo-Replication -- Activity: Configure Auto-Failover Groups -- Summary -- Monitoring and Tuning Azure SQL Database -- Monitoring an Azure SQL Database using the Azure Portal -- Monitoring Database Metrics -- Alert Rules, Database Size, and Diagnostic Settings -- Alert Rules -- Database Size -- Diagnostic Settings -- Query Performance Insight -- Monitor Queries using the Query Performance Insight Blade -- Monitoring an Azure SQL Database using DMVs -- Monitoring Database Metrics -- Monitoring Connections -- Monitoring Query Performance -- Monitoring Blocking -- Extended Events -- Examining Queries -- Tuning an Azure SQL Database -- Automatic Tuning -- Create Index -- Drop Indexes -- Force Last Good Plan -- In-Memory Technologies -- In-Memory OLTP -- Columnstore Indexes -- Activity: Explore the In-Memory OLTP Feature -- Summary -- Index Intro -- Preface -- Microsoft Azure SQL Database Primer -- Azure SQL Database Architecture -- Azure SQL Database Request Flow -- Provisioning an Azure SQL Database -- Connecting and Querying the SQL Database from the Azure Portal -- Connecting and Querying the SQL Database from SQL Server Management Studio -- Deleting Resources -- Differences between Azure SQL Database and SQL Server -- Unsupported Features -- Activity: Provisioning Azure SQL Server and SQL Database using PowerShell -- Summary -- Migrating a SQL Server Database to an Azure SQL Database -- Finding the Migration Benefits -- Finding the Blockers -- Selecting a Service Model -- Selecting a Service Tier -- Selecting the Main and Disaster Recovery Region -- Selecting a Migration Tool -- Azure SQL Database Service Tiers -- Basic Service Tier -- Standard Service Tier -- Premium Service Tier -- Premium RS Service Tier -- Database Transaction Units -- Scaling up the Azure SQL Database Service Tier -- Changing a Service Tier -- Determining an Appropriate Service Tier -- Azure SQL Database DTU Calculator -- Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator -- Determining Compatibility Issues -- Data Migration Assistant -- SQL Server Data Tools for Visual Studio -- SQL Server Management Studio -- SQLPackage.exe -- SQL Azure Migration Wizard -- Determining the Migration Method -- Migrating the On-Premises SQL Server Database to Azure SQL Database -- Activity: Using Data Migration Assistant -- Activity: Performing Transactional Replication -- Summary -- Backing Up the Azure SQL Database -- Automatic Backups -- Backup Storage -- Backup Retention Period -- Configuring Long-Term Backup Retention for Azure SQL Database -- Manual Backups -- Backing up the Azure SQL Database using SSMS -- DACPAC and BACPAC -- Manual versus Automated Backups Professional Azure SQL Database Administration: Equip yourself with the skills you need to manage and maintain your SQL databases on the Microsoft cloud |
| Title | Professional Azure SQL Database Administration |
| URI | https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=5485036 https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781789535679&uid=none |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtZ1Lb9QwEIAt2OVAD-UtWh6yELcoIontrM0NqgUkUFlEQb1Fju2U1WaTssmWll_Cz2XsPEj2BAcuUWLHtpTP8ozHkxmEngumeaii0DeEBz7NUuVzmgqf2VBHgVGSEe2STcyOj_npqVi0efQql05gVhT88lKc_1fUUAaw7a-z_4C77xQK4B6gwxWww3VHI-4fG-KLQZQN79VPezLw-dMH4FpLK6s8OYqT61LyfN8uz72r0jpy5Flrk4V5U62WeV7ZCq8A6Wb108bL1R01rOWysAYF19ANodshuqMH64wP0hdWeE_l5Vb3ltxKrhs77re11EODQ8g7S2Y7RRZSreqBkWy0IQ1nXDDC4iZBzO7ybIVj45Exfm8n4vWo_jqaRpQROkHTt_OPX973BjRiF_OYN3FTbc8vRu320J6sViAoQIjU1Wj_sP_DeSJoc7bZXtXdybdTKE5uo6mxf5ncQddMcRfd6nJr4HapvYd-DWliRxPDp8YdTTym-RI7lrhjiS1LDChww9JWYMsS1yVuWGJgiTuWrqEboGeJy8J10LPEjuV99PXN_OTond9m0fAlqO5U-FpqGmagWqtAcUqyKI54loWwUw6VDgwNhTERVSo1kgrNZBxowrIokDZdGQ0UeYAmRVmYhwizmJhM8EyloNWAHiNsOrNUGdiiQRGNDtCzwUdPLnJ34l8lIzIHCHcsElffuiEn89dHsH9moFNBPzuMEhvZZdzP4d8M9gjd_DOHH6NJvdmaJ-iGuqiX1eZpO6d-A48Teso |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Professional+Azure+SQL+Database+administration%3A+equip+yourself+with+the+skills+you+need+to+manage+and+maintain+your+SQL+databases+on+the+Microsoft+cloud&rft.au=Osama%2C+Ahmad&rft.date=2018-07-31&rft.pub=Packt+Publishing&rft.isbn=9781789535679&rft_id=info:doi/10.0000%2F9781789535679&rft.externalDocID=9781789535679 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97817895%2F9781789535679.jpg |