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