The inside scoop on SQL / debugging you won't find anywhere else!
SQL High Availability
Browse by Tags
Spread the word!
Tagged Content List
PowerShell script to extract T-SQL task code from SSIS packages
Requirement Some time back I presented a PowerShell script which extracts T-SQL code from RDL files. Remember that I created this script to assist me in doing code reviews of ad-hoc SQL snippets which were embedded in the report definition files. Another common usage of ad-hoc T-SQL code is within SSIS...
14 May 2013
PowerShell script to extract T-SQL code from RDL files
One of the things I do in my day job at Microsoft Services is to review database design and T-SQL code. Now, when it comes to code, there is a challenge just to find ALL the possible code which hits our database engine. This is because a non-trivial amount of T-SQL code is not in the form of Stored Procedures...
30 Apr 2013
T-SQL formatter: a PowerShell script
This is a ‘quick-and-not-so-dirty’ version of a T-SQL formatter / ‘pretty printer’ in PowerShell. To use this, please install the SQL 2012 SP1 version of the SQLDOM from the Feature Pack page . (If you already have SQL 2012 client tools on your machine, you should be ready to go.) And you will need PowerShell...
28 Feb 2013
Page 1 of 1 (3 items)
© 2014 Microsoft Corporation.
Privacy & Cookies