Cargando…

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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Osama, Ahmad
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing Ltd, 2018.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000Mi 4500
001 EBOOKCENTRAL_on1048801205
003 OCoLC
005 20240329122006.0
006 m o d
007 cr |n|---|||||
008 180818s2018 enk o 000 0 eng d
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d YDX  |d MERUC  |d CHVBK  |d OCLCO  |d OCLCF  |d OCLCQ  |d OCLCO  |d LVT  |d UKAHL  |d OCLCQ  |d OCLCO  |d UX1  |d K6U  |d NLW  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
019 |a 1048129352  |a 1175643008 
020 |a 9781789535679 
020 |a 1789535670 
020 |a 9781789538854 
020 |a 1789538858  |q (Trade Paper) 
024 3 |a 9781789538854 
029 1 |a AU@  |b 000065314103 
029 1 |a CHNEW  |b 001024208 
029 1 |a CHVBK  |b 530305186 
035 |a (OCoLC)1048801205  |z (OCoLC)1048129352  |z (OCoLC)1175643008 
037 |a B11598  |b 01201872 
050 4 |a QA76.9.C55  |b .O836 2018 
082 0 4 |a 005.7585 
049 |a UAMI 
100 1 |a Osama, Ahmad. 
245 1 0 |a Professional Azure SQL Database Administration :  |b Equip Yourself with the Skills You Need to Manage and Maintain Your SQL Databases on the Microsoft Cloud. 
260 |a Birmingham :  |b Packt Publishing Ltd,  |c 2018. 
300 |a 1 online resource (398 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
588 0 |a Print version record. 
505 0 |a 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. 
505 8 |a Selecting a Service ModelSelecting 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. 
505 8 |a SQL Server Data Tools for Visual StudioSQL 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. 
505 8 |a Activity: Perform Back-upsSummary; 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. 
505 8 |a Using Active Directory -- Password to Authenticate to an Azure SQL DatabaseAzure 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. 
500 |a Scale Up or Scale Down Service Tiers. 
520 |a 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 ... 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a SQL server. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Database management. 
650 6 |a Bases de données  |x Gestion. 
650 7 |a Information technology: general issues.  |2 bicssc 
650 7 |a Cloud computing.  |2 bicssc 
650 7 |a Databases.  |2 bicssc 
650 7 |a Computers  |x General.  |2 bisacsh 
650 7 |a Computers  |x Database Management  |x General.  |2 bisacsh 
650 7 |a Database management  |2 fast 
758 |i has work:  |a Professional Azure SQL Database Administration (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCYHM6CyP8MHdrxtPxhKprm  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Osama, Ahmad.  |t Professional Azure SQL Database Administration : Equip Yourself with the Skills You Need to Manage and Maintain Your SQL Databases on the Microsoft Cloud.  |d Birmingham : Packt Publishing Ltd, ©2018  |z 9781789538854 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=5485036  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n BDZ0037629809 
938 |a EBL - Ebook Library  |b EBLB  |n EBL5485036 
938 |a YBP Library Services  |b YANK  |n 15625737 
994 |a 92  |b IZTAP