Break the boundaries of the traditional (T)SQL language

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 up to SQL Server 2019.

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 review tools like xp_cmdshell, SQLCLR, Python, R, Java, Undocumented Registry extended Stored Procedures, working with Component Object Model (COM), and more...

level 300-400

Ronen Ariely

Senior consultant and architect, data platform and application development.

Tel Aviv, Israel


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top