Clustered Columnstore Indexes (CCI)
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
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