Break the boundaries of the traditional (T)SQL language​ - Ronen Ariely

Presentation Title: Break the boundaries of the traditional (T)SQL language

Description:
While the traditional DBA role that works with RDBMS databases focuses on running queries against tables, in practice, SQL Server provides powerful tools that allow to connect and to control the host environment and to process and analyze the data using embedded external tools/languages.

I will open this session with a review of some of the documented tools and features, followed by a deep dive into undocumented tools and new features added in recent years.

This session is an overview that is suitable for anyone who wants to confirm that he is aware of the options available or for those who just want to fill in the blanks.

We will start with reviewing tools like xp_cmdshell, SQLCLR, Python, R, Java and dive to undocumented features, control Registry and extended Stored Procedures, working with Component Object Model (COM), and more...