Episode 233: ScriptDOM

Episode 233: ScriptDOM

Episode 233: ScriptDOM 560 420 Carlos L Chacon

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries.

Mala Mahadevan

Our Guest

Mala Mahadevan

Mala Mahadevan is a senior database professional with over 20 years of experience working with data, primarily in SQL Server and related technologies. She has been volunteering with SQL Server community for the past 15 years and is also a recipient of the PASSion award for being an outstanding volunteer. She is a featured blogger on sqlservercentral.com and also blogs frequently at curiousaboutdata.com. She is active on Twitter as @sqlmal.

Never Miss An Episode

Subscribe to get podcast notifications by email.

It’s a beautifully engineered [product], but because it’s not documented, it’s not easy for someone to just go in there and use it.

Mala Mahadevan

3 Takeaways

  1. ScriptDOM allows you to create a document object model of a T-SQL query. You can then parse elements of the query just like SQL Server Management Studio does. It creates an abstract syntax tree (AST) representing the query.
  2. ScriptDOM provides two ways to parse the resulting tree: walk through the elements directly or use the Visitor pattern to find just the elements you want.
  3. ScriptDOM allows you to parse an existing query, check for syntax errors, and perform static code analysis. It will not generate a new T-SQL query from a syntax tree, so it is not an object-relational mapper (ORM).

Imagine what’s possible with a dedicated SQL specialist on your team.

Leave a Reply

Back to top