The detailed explanation could be found on Red Gate SimpleTalk's link 'SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server' https://www.red-gate.com/simple-talk/sql/sql-development/sqlclr-practice-creating-better-way-sending-email-sql-server/

The detailed explanation could be found on Red Gate SimpleTalk's link 'An Easier Way of Transposing Query Result in SQL Server' https://www.red-gate.com/simple-talk/sql/t-sql-programming/easier-way-transposing-query-result-sql-server/

edX course Microsoft: DAT201x Querying Data with Transact-SQL

Logging API for SQL Server

SQL Server Linked Server's aliasing workaround

Algumas t-sqls de alguns projetos que participei

Handy collection of SQL scripts, snippets, stored procedures, and functions.

Database model for Management app and functionality.

Collection of Microsoft Training classes sponsored by Pragmatic Works, Inc.

SQL Server-based solutions for https://adventofcode.com/2017

T-SQL and sending mails

SQL_drills

This is a repository with a list of a very useful functions in Transact SQL to use in querys.

Final class project