TSQL Programming
- What is Collation is SQL Server and how it works
- GUID in Sql Server
- PIVOT, Multi Pivot & Dynamic Pivot in SQL Server
- Mutex in Sql Server
- Recursive CTE
- Bookmark lookup tipping point
- Conditional branching and OPTION(Recompile)
- Statistics used in the cached execution plans
- Pivoting with Python in Sql Server
- Temporary tables statistics when used in stored procedures
- Adding non-NULL value columns ONLINE
- ORDER BY – Changes everything
- Semi Joins, anti-joins and Nulls in Sql Server
- Three valued logic – NULL in Sql Server
- Short–Circuit evaluation in Sql Server
Security
Data Layer
- Data providers and User Options
- Client Requests & Sql events in Sql Server
- XACT_ABORT and Query Timeout in Sql Server
High Availability and Disaster Recovery
Quick TSQL Thoughts