Microsoft® Azure™ SQL Database Step by Step

Index

A

abstraction, 3–4, 217, 313

access control, 12, 35–38, 106–111, 170

least privilege principle, 108–109, 111

with stored procedures, 307–312

action methods, 321, 326–327, 338

Active Directory, adding users, 170

ADO.NET, 217

connection pooling, 234

data access layer, building, 312–313

database connections, managing, 234

Dataset objects and data adapters, 313

encapsulating, 239

raw objects, 312–313

sharding with, 254–259

SqlConnection class OpenWithRetry extension method, 59

transient fault handling, 237–238

Web API controllers, building, 230–233

AdventureWorks database, installing, 151–154

agent keys, 204

Agent service, 59

agents, 174

aging policies, 56

allowed IP addresses, 12

See also firewall rules; SQL Database Firewall

ALTER DATABASE ...