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
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
Export to Excel https://github.com/ClosedXML/ClosedXML
Basics of Active Reports https://www.grapecity.com/activereportsnet
Basics of Power BI Data Visualization | Microsoft Power BI
Comments
Post a Comment