Atjaunināt sīkdatņu piekrišanu

E-grāmata: Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals

4.12/5 (11 ratings by Goodreads)
  • Formāts: PDF+DRM
  • Izdošanas datums: 30-Oct-2020
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484259313
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 47,58 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Azure SQL Revealed: A Guide to the Cloud for SQL Server ProfessionalsPalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 30-Oct-2020
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781484259313
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused. 

If you know SQL Server, you will love this book. You will be able to take your existing knowledge of SQL Server and translate that knowledge into the world of cloud services from the Microsoft Azure platform, and in particular into Azure SQL. This book provides information never seen before about the history and architecture of Azure SQL. Author Bob Ward is a leading expert with access to and support from the Microsoft engineering team that built Azure SQL and related database cloud services. He presents powerful, behind-the-scenes insights into the workings of one of the most popular database cloud services in the industry.


What You Will Learn
  • Know the history of Azure SQL
  • Deploy, configure, and connect to Azure SQL
  • Choose the correct way to deploy SQL Server in Azure
  • Migrate existing SQL Server instances to Azure SQL
  • Monitor and tune Azure SQL’s performance to meet your needs
  • Ensure your data and application are highly available
  • Secure your data from attack and theft

Who This Book Is For

This book is designed to teach SQL Server in the Azure cloud to the SQL Server professional. Anyone who operates, manages, or develops applications for SQL Server will benefit from this book. Readers will be able to translate their current knowledge of SQL Server—especially of SQL Server 2019—directly to Azure. This book is ideal for database professionals looking to remain relevant as their customer base moves into the cloud.  



Intermediate-Advanced user level
About the Author xv
About the Technical Reviewer xvii
Foreword xix
Acknowledgments xxi
Introduction xxiii
Chapter 1 SQL Server Rises to the Clouds
1(38)
CloudDB
2(1)
The Red Dog
3(1)
The Azure Services Platform
4(4)
The Road to SQL Azure
8(8)
SQL Data Services
9(4)
SQL Azure Is Born
13(3)
The SAWA Project
16(1)
The Virtual Machine Initiative
16(3)
Becoming Azure SQL Database
19(11)
The Sterling (SAWAv2) Project
20(5)
New Editions, the DTU, and Previews
25(1)
Intelligent Performance and the MDCS
26(1)
Advanced Data Security and the ILDC Team
27(1)
A Pane for the Future Called Ibiza
28(1)
A New Engineering Model for Azure
29(1)
Bending Azure SQL Database
30(1)
Lifting Customers to the Cloud
31(1)
Project Socrates Goes Hyper
32(3)
Azure SQL Today
35(4)
Chapter 2 What Is Azure SQL?
39(42)
The Azure Ecosystem
40(12)
Azure Accounts and Subscriptions
40(2)
The Azure Portal
42(3)
The Azure Marketplace
45(1)
Azure API and CLI
46(1)
Azure Resource Manager (ARM)
47(3)
Azure Monitor
50(1)
Azure Regions and Datacenters
50(1)
Azure Service-Level Agreement (SLA)
51(1)
What Is the Azure SQL?
52(3)
IaaS vs. PaaS
52(1)
The Azure SQL Lineup
53(2)
Azure SQL Managed Instance
55(7)
Managed Instance Capabilities
56(1)
Managed Instance Options and Limits
57(2)
Managed Instance Pools
59(1)
Managed Instance vs. SQL Server on Azure Virtual Machine
60(1)
Customers Using Managed Instance
61(1)
Azure SQL Database -
62(10)
Azure SQL Database Capabilities
62(1)
Azure SQL Database Options and Limits
63(7)
Azure SQL Database vs. Azure SQL Managed Instance
70(1)
Customers Using Azure SQL Database
71(1)
Interfaces for Azure SQL
72(8)
Azure Portal
72(2)
Az CLI
74(1)
PowerShell
75(1)
REST API
75(1)
TDS and T-SQL
76(1)
SQL CLI
77(1)
SQL Server Management Studio (SSMS)
77(1)
Azure Data Studio (ADS)
78(1)
Visual Studio Tools
79(1)
Summary
80(1)
Chapter 3 SQL Server on Azure Virtual Machine
81(60)
Deploying
82(7)
Pricing
82(1)
SQL Server Gallery Images
83(3)
Resource Group, Region, and Availability
86(3)
Virtual Machine Sizes
89(35)
Account, Port, and OS Licensing
93(1)
Making Configuration Choices As Part of Deploy
94(14)
Deploy!
108(3)
Navigating in the Portal
111(2)
Connecting to Your VM
113(2)
Exploring the SQL Server Installation
115(2)
Deploy on Your Own
117(1)
Using a CLI and ARM Template
118(2)
Reserved Instances and Dedicated Hosts
120(1)
Migrate Using Azure Migrate
121(1)
Deploying SQL Server on Linux with Azure Virtual Machine
122(1)
Deploying SQL Server Containers
123(1)
SQL Virtual Machine Resource Provider
124(2)
Configuration
126(2)
Stopping vs. Deallocating
126(1)
Resizing
127(1)
Security
127(1)
Other Config Options
128(1)
Maximizing Storage Performance
128(2)
Performance Monitoring
130(4)
Azure Metrics
130(2)
Logs
132(1)
Insights
133(1)
Networking
134(1)
HADR
135(4)
Azure Storage
136(1)
Backups
136(1)
Always On Failover Cluster Instance
137(1)
Always On Availability Groups
137(1)
Go Further with Azure Availability
138(1)
SQL Server and Linux Availability
138(1)
Summary
139(2)
Chapter 4 Deploying Azure SQL
141(62)
Pre-deployment Planning
142(7)
New Deployment or Migration
142(1)
Making Deployment Choices
143(5)
Consider Resource Limits
148(1)
Deploying Azure SQL Managed Instance
149(19)
Deployment and Options
150(9)
Deploying with a CLI
159(1)
Implementation Details
159(2)
Connecting and Verifying Deployment
161(7)
Migrating to Azure SQL Managed Instance
168(3)
Assessment and Planning
168(2)
Migration
170(1)
Application Changes
170(1)
Post Migration
171(1)
Deploying an Azure SQL Database
171(29)
Deployment and Options
171(12)
Deploying Business Critical
183(2)
Deploying Serverless
185(1)
Deploying Hyperscale
186(1)
Deploying with a CLI
187(1)
Implementation Details
188(6)
Connecting and Verifying Deployment
194(6)
Migrating to Azure SQL Database
200(2)
Summary
202(1)
Chapter 5 Configuring Azure SQL
203(32)
Configuring Azure SQL Managed Instance
204(6)
sp_configure
204(1)
Trace Flags
205(1)
Tempdb
205(1)
Master and Model
206(1)
Configuring Edition
206(1)
Networking Configuration
206(2)
Configuring Databases
208(2)
Configuring Azure SQL Database
210(4)
Creating New Databases
210(2)
Altering Databases
212(1)
Network Configuration
213(1)
Configuration Restrictions
214(5)
Azure SQL Managed Instance Restrictions
214(4)
Azure SQL Database Restrictions
218(1)
Azure SQL Space Management
219(2)
Azure SQL Managed Instance Space Management
219(1)
Azure SQL Database Space Management
220(1)
Loading Data
221(10)
Keep These in Mind
221(1)
BCP
222(1)
Bulk Insert and Openrowset
223(1)
SQL Server Integration Services (SSIS)
224(2)
BACPAC
226(1)
Database Copy
227(1)
RESTORE to Managed Instance
228(1)
Spark Connector
229(1)
Azure Data Factory (ADF)
229(1)
SQL Data Sync
230(1)
Replication Subscriber
230(1)
Updating Azure SQL
231(3)
Maintenance of Azure SQL
231(2)
New Features and Capabilities in Azure SQL
233(1)
Summary
234(1)
Chapter 6 Securing Azure SQL
235(70)
Security Capabilities and Tasks
237(2)
Security Capabilities
237(1)
Security Tasks
238(1)
Network Security
239(17)
Azure SQL Managed Instance Network Security
240(3)
Azure SQL Database Network Security
243(13)
Authentication and Access
256(10)
Azure Role-Based Access Control (RBAC)
256(1)
Authentication for Azure SQL Managed Instance
257(2)
Authentication for Azure SQL Database
259(7)
Set Up and Configure Access
266(1)
Protecting Your Data
266(8)
Encrypting Connections
266(1)
Transparent Data Encryption (TDE)
267(5)
Always Encrypted
272(1)
Dynamic Data Masking (DDM)
272(2)
Monitoring Security
274(12)
Monitoring the Azure Ecosystem
274(2)
Auditing Azure SQL Managed Instance
276(1)
Auditing Azure SQL Database
277(9)
Advanced Data Security
286(17)
Data Classification
288(7)
Vulnerability Assessment
295(4)
Advanced Threat Protection (ATP)
299(2)
Azure Security Center
301(2)
Summary
303(2)
Chapter 7 Monitoring and Tuning Performance for Azure SQL
305(68)
Performance Capabilities
306(7)
Max Capacities
307(3)
Indexes
310(1)
In-Memory OLTP
311(1)
Partitions
311(1)
SQL Server 2019 Enhancements
312(1)
Intelligent Performance
312(1)
Configuring and Maintaining for Performance
313(4)
Tempdb
313(1)
Database Configuration
314(1)
Files and Filegroups
314(1)
Max Degree of Parallelism
315(1)
Resource Governor
315(1)
Maintaining Indexes
316(1)
Maintaining Statistics
316(1)
Monitoring and Troubleshooting Performance
317(29)
Monitoring Tools and Capabilities
317(2)
Dive into DMVs and Extended Events
319(5)
Performance Scenarios
324(19)
Azure SQL Specific Performance Scenarios
343(3)
Accelerating and Tuning Performance
346(17)
Scaling CPU Capacity
346(10)
I/O Performance
356(1)
Increasing Memory or Workers
356(1)
Improving Application Latency
357(1)
Tune Like It Is SQL Server
358(5)
Intelligent Performance
363(9)
Intelligent Query Processing
363(1)
Automatic Plan Correction
364(1)
Automatic Tuning
365(7)
Summary
372(1)
Chapter 8 Availability for Azure SQL
373(68)
HADR Capabilities
375(2)
Automatic Backups and Point-In-Time restore
375(1)
Built-in High Availability
375(1)
Azure Redundancy
376(1)
Geo-replication and Auto-failover Groups
376(1)
Database Availability and Consistency
376(1)
SQL Server Replication
377(1)
Backup and Restore
377(17)
Automatic Backups
378(3)
Point-In-Time restore
381(7)
Long-Term Retention Backups
388(3)
Geo-restore of Databases
391(1)
Restore Backups from Deleted Databases -
392(1)
Restore in Azure SQL Managed Instance
393(1)
Built-in High Availability
394(16)
General Purpose High Availability
395(3)
Business Critical High Availability
398(6)
Hyperscale High Availability
404(6)
Go Further with Azure
410(20)
Zone Redundancy
410(3)
Geo-replication
413(6)
Auto-failover Group
419(9)
Azure SQL SLA
428(2)
Database Availability and Consistency
430(2)
Database Availability
430(1)
Accelerated Database Recovery (ADR)
431(1)
Database Consistency
431(1)
Monitoring Availability
432(7)
Instance, Server, and Database Availability
432(1)
Backup and Restore History
433(1)
Region, Data Center, and Service Availability
434(2)
Replica Status
436(2)
Failover Reasons
438(1)
System Center Management Pack for Azure SQL
439(1)
Summary
439(2)
Chapter 9 Completing Your Knowledge of Azure SQL
441(30)
Surface Area of Azure SQL
442(5)
Linked Servers and Cross-Database Queries
443(1)
External Tables
444(1)
Database Mail
444(1)
Service Broker
445(1)
Full-Text Search
446(1)
Machine Learning Services
446(1)
What Is Missing?
447(1)
Job Management
447(11)
SQL Server Agent
448(1)
Elastic Jobs
449(8)
Azure Automation
457(1)
Supporting Azure SQL
458(7)
Handling Errors
458(2)
Stack Dumps
460(1)
Troubleshooting Resources in the Azure Portal
460(5)
User Voice
465(1)
Azure SQL Best Practices
465(5)
Security Playbook
465(2)
Best Practices for Performance
467(1)
Azure Advisor
467(2)
Stay in Touch with Our Team
469(1)
Summary
470(1)
Chapter 10 Go Big with the Cloud
471(16)
Integration with Azure Services
471(10)
Power Platform
472(4)
Azure Search
476(5)
Stream Analytics
481(1)
Azure Architectures and Solutions
481(2)
Azure Synapse
483(1)
Azure Arc
483(1)
Summary
484(3)
Index 487
Bob Ward is a principal architect for the Microsoft Azure Data Server team, which owns the development for all SQL Server versions. He has worked for Microsoft for more than 27 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019, including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft //build, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms and linkedin.com/in/bobwardms. Bob is the author of the Apress books Pro SQL Server on Linux and SQL Server 2019 Revealed.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814842593132e.html