Index

A

abstraction, 34, 217, 313

access control, 12, 3538, 106111, 170

least privilege principle, 108109, 111

with stored procedures, 307312

action methods, 321, 326327, 338

Active Directory, adding users, 170

ADO.NET, 217

connection pooling, 234

data access layer, building, 312313

database connections, managing, 234

Dataset objects and data adapters, 313

encapsulating, 239

raw objects, 312313

sharding with, 254259

SqlConnection class OpenWithRetry extension method, 59

transient fault handling, 237238

Web API controllers, building, 230233

AdventureWorks database, installing, 151154

agent keys, 204

Agent service, 59

agents, 174

aging policies, 56

allowed IP addresses, 12

See also firewall rules; SQL Database Firewall

ALTER DATABASE ...

Get Microsoft® Azure™ SQL Database Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.