🔢SQL Server

A list of resources on Azure SQL, SQL Server and Azure Synapse Analytics:

SQL Server

• Business Continuity 
• Backup and restore
• Always On availability groups
• Always On failover cluster instance
• Database mirroring
• Log shipping
• Replication
• Manage & Monitoring
• Transaction log management
• Maintenance plans
• SQL Server Agent
• Track changes
• Data compression
• Extended events (XE)
• Security
• Access management
• Always Encrypted
• Enclaves
• Auditing
• Dynamic data masking
• Transparent data encryption (TDE)
• Row-level security
• Tune
• Performance center
• Intelligent Query Processing (IQP): Gohuri
• Automatic tuning
• Database Tuning Advisor
• In-memory OLTP
• Concept
• Cardinality estimation
• Statistics
• Indexes
• clustered vs. non-clustered: local
• Key Concepts
• buffer pool: [local]
• checkpoints
• compression
• garbage collection
• live query statistics
• logging
• minimally logged
• locking
• memory
• memory manager
• NUMA
• objects
• cursor:
• database:
• model database:
• tempdb database:
• functions
• aggregate functions
• analytics functions
• system functions
• table-valued functions
• user-defined functions
• indexes:
• clustered index 
• clustered vs non-clustered indexes: [local]
• composite indexes:
• covering indexes:
• index selectivity:
• non-clustered indexes:
• keys
• composite key:
• foreign key:
• primary key:
• stored procedures:
• system stored procedures:
• user-defined stored procedures:
• tables:
• contained database:
• resource database:
• scalable shared database:
• stretched databases:
• table variables:
• tempdb:
• temporal databases:
• temporary tables:
• triggers:
• views:
• user-defined views:
• indexed views:
• system views:
• parameter sniffing:
• partitions:
• plan cache:
• queries:
• correlated subquery: 
• query optimization:
• query plan: [local]
• query processing:
• subqueries:
• real-time operational analytics:
• resource governor:
• resource monitor:
• service broker:
• sessions:
• transaction log:
• transactions:
• variables:
• query plan:

Professionals in the Field

• Bradley Ball: @SQLBalls
• Deepthi Goguri: @dbanuggets, web
• Matt Gordon: @sqlatspeed, web
• Jason Hayley: @haleyjason, web
• Anna Hoffman: @AnalyticAnna
• Davide Mauri: @mauridb, web
• Shireesh Thota @ShireeshThota
• Buck Woody: @BuckWoodyMSFT
• Bob Ward @bobwardms

Resources

• Ideas [link] ✨
• Try Azure SQL Database free [link] 🆓
• Azure trial [link] 🆓