Index
A
AddRange() method
Advanced data security (ADS)
Advanced Threat Protection
Apache Spark
Application Insights Agent
Application Map
Application Performance Management (APM) service
AVX and SIMD instructions
Azure Blob
Azure Cognitive Search index service
Azure Cosmos DB
Azure Data Studio (ADS)
Azure Kubernetes Service
Azure Monitor
logs and metrics
long-term analytical options
Azure portal
Azure Portal experience
Azure SQL
abstraction and access level
adding data
ADS
advantages
aggregations
grouping data
multiple grouping
Windowing Functions
Bulk Copy API
cloud-native entity
collation awareness
collations
compute to data pushing
connection methods
create database
Cypher expressions
data assets protection
Always Encrypted feature
dynamic data masking
features
permissions management
RLS
data monitoring
change data capture
change tracking
example
declarative vs. imperative
DTU or vCores
Elastic Pools
Flightlines CSV file
functions
geometry vs. geography
graph capabilities
graph processing support
graph structures
hardware generation
identity and sequences
instance-level features
Instance Pools
JSON
B-Tree index
built-in functions
data exchange format
data integrity
double-check condition
FOR JSON clause
Formatting query results
functionalities
importing documents
indexing values
NEAR operator
OPENJSON function
paths
querying data
storing documents
text and extract information
XML data
key-value pairs
merging data
modifying data
multi-model capabilities
networking
Node tables
non-scalar parameters
CSV
JSON
TVP
NoSQL scenario
OFFSET/FETCH
Open Geospatial Consortium
output clause
primary XML index
Python/R
querying XML data
relational semi-structured data
removing data
retrieving data
alias
COLLATION
Common Table Expressions
filtering
joins
quoted identifiers
Sales.Invoices table
sample SELECT result
SELECT command
semicolon
subquery
T-SQL statement
two-part names
unicode strings
UNION statement
schema-on-read
secondary XML index
selective XML indexes
semi-structured data
service tiers
smaller minimum configuration
spatial data
spatial data types
spatial indexes
spatial support
STIntersects method
Stored Procedures
STOverlaps method
structured information
table design
SeeTable design
temporary tables
tessellation
Time zone setting
tools
Triggers
unstructured text
HTML code
indexing
LIKE operator
querying
using sample databases
variables
views
XML support
XPath and XQuery languages
B
BeginTransaction() method
B-Tree index
Bulk Copy API
Business rules
C
Checkpoint
Cloud-based solutions
Clustered Columnstore Indexes (CCI)
Clustered Index
Columnstore
Columnstore format
analytical and reporting queries
batch mode execution
Clustered Columnstore Indexes (CCI)
Clustered Index
column segments
compressed area
compression algorithms
Deltastore area
full-scan queries
high data compression
memory caching architectures
modifications
nonclustered Columnstore Indexes (NCCI)
NVARCHAR columns
organization
pages
partitioning technique
querying structure
Rowstore format
SIMD operations
Updating values
Columnstore indexes
Command Query Responsibility Segregation (CQRS)
Comma-Separated -Values (CSV)
Connecting and querying
brand-new physical connectio
cloud environment
connection pooling
custom code or reusable libraries
data access frameworks
default connection policy
driver and libraries
frameworks, ORM, and MicroORM
full .NET Framework
Java application
MicroORMs
.NET Core application
Node.JS function
ORMs
pof.xml
private VNET
programming languages
proxy
public connectivity
pyodbc
Python
pythonic spirit
RAISERROR function
redirect
retry logic
roundtrips to database
server- and database-level firewall rules
service-to-service interactions
simple Python application
transient and persistent errors
T-SQL language
using Entity Framework Core
using read-only replicas
using SQLAlchemy
VNET Service Endpoint
Continuous Integration (CI)/Continuous Deployment (CD)
Azure DevOps
challenges
Code First approach
comparison tools
dacpac file
data integrity and performances
DbUp
definition
GitHub Actions
integration environment
ORM usage
synthetic environment
D
Database Advisor
Databases
Database transaction unit (DTU)
Data definition language (DDL)
Data manipulation
Data manipulation language (DML)
Data Migration Assistant (DMA) tool
Delete bitmaps
Delete indexes
Denormalization
DevOps
CI/CD
Azure DevOps
challenges
Code First approach
comparison tools
dacpac file
data integrity and performances
DbUp
definition
GitHub Actions
integration environment
ORM usage
synthetic environment
database testing
Domain- Driven Design (DDD) theory
Domain-Driven Development (DDD)
Dynamic management views (DMVs)
client tool of preference
Database Advisor
diagnose performance problems
diagnostic query
execution plan
Query Performance Insight
Query plans
Query store
Query Wait Statistics
Regressed Queries
T-SQL commands
VIEW DATABASE STATE
views and functions
VIEW SERVER STATE
E
Encoding schema
EVENTDATA function
F
Fixed mindset
Flightline
Foreign Key
Full-Text Search (FTS) index
G
Generalized Inverted Index (GIN)
getorders()
Globally unique identifier (GUID) values
Graphical user interface (GUI)
Growth mindset
H
Heap table
Highly normalized relational model
HikariCP
I
Infrastructure as a Service (IaaS)
Inline Table-Valued Functions
Inter-Process Communication (IPC) mechanisms
Isolation levels
J
JSON
K
Key column(s)
L
Language-Integrated Query (LINQ)
Lock hierarchy
Locking mechanisms
Lock manager
M
Memory-optimized tables
advantages
CLUSTERED COLUMNSTORE indexes
Columnstore format
Columnstore Indexes
Columnstore tables
durable tables
interoperability
new row version
NONCLUSTERED B-Tree indexes
NONCLUSTERED HASH index
non-durable schema-only tables
READ COMMITTED or READ UNCOMMITTED transaction isolation levels
Redis or Cosmos DB
row versioning
WITH clause
WITH options
WITH(SNAPSHOT) hint
MicroORMs
Microsoft.Data.SqlClient
Microsoft JDBC Driver 8.2
Multi-granular locking
Multi-model databases
Azure SQL, 193, 197
SeeAzure SQL
dogmatic architectural decisions
dogmatic decisions
Domain-Driven Development (DDD)
graph models
Highly normalized relational model
lazy loading techniques
non-relational data
NoSQL approach
Order and Invoice entities
semi-structured data entities
structured data entities
unstructured data entities
Multi-Statement Table-Valued Function
Multi-Version Concurrency Control (MVCC)
N
.NET/.NET Core
.NET/ Python code
Network security
Nonclustered Columnstore Indexes (NCCI)
Non-clustered indexes
Non-loss decomposition process
Normal form
Normalization process
O
Object-Relational Mappers (ORM)
OnModelCreating methods
Open Geospatial Consortium
Optimistic concurrency
ORM
P
Persisted computed columns
Platform as a Service (PaaS)
PolyBase
Polyglot persistence
PostalCityID column
Primary Key
Purchasing model
pyodbc methods
Python
Python/R
Q
Query store
R
Race conditions
Read Committed Snapshot Isolation (RCSI)
Referential integrity
Regressed Queries
Relational model
Resource Group
Row-Level Security (RLS)
Row versioning
S
schema-on-read approach
SELECT statement
Service-level agreement (SLA)
Service tiers
setTransactionIsolation() method
Shared Schema Lock (SCH-S)
Single Instruction Multiple Data (SIMD) operations
SKU Recommender
Software as a Service (SaaS)
Spatial columns
SqlBulkCopy class
SqlCommand
SqlConnection and SqlCommand classes
SqlDataReader
SQL Server Data Tools (SSDT)
SQL Server Management Studio (SSMS)
T
Table design
CREATE TABLE statement
declarative constraints
Domain Model entities
Bounded Context
high-level guidelines
normalization
redundancy
fn_my_permissions function
indexes
B-Tree index
clustered index
creation
heap table
maintenance operations
performance issues
recommendations
right column types
collation
complex-type columns
computed columns
definition
SQL column type
SalesMicroservice
Table-Valued Functions (TVF)
Table-Valued Parameter (TVP)
Tabular Data Stream (TDS)
TelemetryClient
Temporal tables
auditing
configuring
error correction
historical analysis
History Table
querying temporal data
Transactional systems
auto-commit
BeginTransaction() method
blog
concurrency settings
database roundtrips optimization
batching calls
bulk copy
leveraging transactions
parameterized INSERT statement
recommendations
table-valued parameters
description
distributed transactions
example
explicit
implicit
isolation levels
local transactions
auto-commit property
BEGIN TRANSACTION
BEGIN TRY block
code readability
DMVS
error message and database tables
nested transactions
.NET Core
Orders and Inventory tables
Python
rollback results
savepoint
Stored Procedure
T-SQL example
locks
natively compiled Stored Procedures
RCSI
row versioning
setTransactionIsolation() method
table hints
Transact-SQL commands
WAL
Transact-SQL commands
Transient Fault Handling (TFH) Application Block
Transparent Database Encryption
T-SQL code
T-SQL language
U
Unicode standard
User-Defined Functions (UDF)
V
vCore model
Virtual machine (VM)
Virtual network (VNet)
VNET Network Security Group (NSG)
W
WideWorldImporters
World Geodetic System 1984 (WGS84)
Write-ahead logging (WAL)
WWImportersContext class
X, Y, Z
XACT_ABORT ON
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.