The inside scoop on SQL / debugging you won't find anywhere else!
Mumbai Tech Community
SQL High Availability
SQL Server 2014
SQL Wait Types
Browse by Tags
Spread the word!
Tagged Content List
Using PowerShell to attach PST files to Outlook
This one is a really quick note. Yet another example to show off the power of the PowerShell pipeline and its interoperability with the COM world. Recently I had to add 30+ existing PST files to an instance of Outlook. I hate using the mouse and keyboard for repetitive tasks (File –> Open Outlook...
11 Dec 2014
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 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies