Starting from Microsoft® SQL Server 2005, developers got chance to write code which can be executed in their favorite language, using available .NET classes. This addition spread different discussions about future of T-SQL and usability of SQLCLR. Transact-SQL (T-SQL) is the native programming language supported by SQL Server. Like most versions of SQL, it contains data manipulation features. The data manipulation features can be broadly categorized into two parts: a declarative query language (composed of SELECT/INSERT/UPDATE/DELETE statements) and a procedural language (WHILE, assignment, triggers, cursors, etc.) Broadly speaking, CLR support in SQL Server provides an alternative to the procedural portion of T-SQL. Presentation will compare CLR-based programming against existing programming models supported in SQL Server, highlight the relative strengths and weaknesses of each technique, and provide a set of high-level guidelines on how to choose between the available programming alternatives. This will be the main goal of this presentation, explained in details by using many demos for all of the features including solutions for common problems few tricks to achieve best performance.