Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about producing a Stored Procedure Call Tree and even built the Test-SqlScript and Out-SqlScript cmdlets included in SQL Server PowerShell Extensions using the assemblies. Recently I’ve discovered another useful SQL parser called MacroScope that’s worthy of…
Tag Archive: VSDB
Stored Procedure Call Tree
I was reading a post by Linchi Shea in which he demonstrates a Perl script to Find the complete call tree for a stored procedure and thought, how would I do this in PowerShell? Before we dissect a PowerShell approach, let’s look at a basic Perl approach. In Perl you typically find a command-line tool…
Test-SqlScript and Out-SqlScript cmdlets
I ‘ve been using Visual StudioTeam System 2008 Database Edition (VSDB) and noticed an interesting post on Gert Drapers’ blog, entitled Getting to the Crown Jewels. In the posting Gert demonstrates a basic C# WinForm application which parsers and formats T-SQL using the assemblies Microsoft.Data.Schema.ScriptDom and Microsoft.Data.Schema.ScriptDom.Sql included in VSDB. A subsequent posting states if you own an…
Installing Visual Studio Team System 2008 Database Edition
I’ve been following Visual Studio Database Edition (VSDB) aka Data Dude, since the initial release over two years. The best overview of VSDB I’ve seen recently is a presentation given by Gert Drapers at PDC2008. Until recently I’ve only been able to look at the product from a distance attending several presentations at various SQL Server conferences, but never…
