The PASS Application Development VC serves as a hub of free training and information for application developers working with Microsoft SQL Server, and techniques and helping fellow community members avoid trials and tribulations.
Next Meeting

Fri, Nov 01 2013 07:00 Mountain Daylight Time

DIY:T-SQL Swiss Knife Using ScriptDOM T-SQL parser

RSVP: None

Meeting URL:

DIY: T-SQL Swiss Knife Using the ScriptDOM T-SQL Parser

Want to find out how exactly many DELETE statements in your database? Even better, how many of those are missing a WHERE clause? Or maybe you want to check your code for the usage of the COMPUTE clause, but Upgrade Advisor does not help you do so? Or maybe you want to ‘pretty print’ your SQL scripts? Many such requirements can be easily taken care of by using the TransactSql.ScriptDom parser which ships with SQL Server 2012. This session is for DBAs and developers who want to dig DEEP into the T-SQL code with simple C# and PowerShell scripts. And thereby end up making their jobs (and lives) easier!

Arvind Shyamsundar is a Principal Premier Field Engineer with Microsoft Services