April 2022 Learnings

SQL Server:
Performance Tuning - Execution plan, profiler, extended events, query store
Database normalization
Stored Procedure, Functions and temp tables
CLR Functions
Database Security
Database backup and restore
Indexes (Clustered, Non-clustered with included columns, filtered, xml)
Dynamic Data Masking
Row Level Security
Common Table Expressions
JSON
XML and xquery
Dynamic Managerment Views
Cross Apply, Ranking functions
DACPAC including pre and post deployment scripts; one shot scripts
SSIS 2008


Requirements gathering



Comments

Popular posts from this blog