Contents tagged with Tools

  • Cool Extension for Visual Studio 2010

    550 comments

    i have been using Power Commands for Visual Studio for a long time. but i had never noticed that it’s a got very good feature for automatically formatting the document on save. not only it can format the document, but also it can remove and sort using statements in the files when you save them.

    it this really good for me because we use stylecop to enforce coding standard within our dev team.

    it’s also good when you refactor your code and end up changing namespaces and class names.

    to install the extension. click on the extension manager in the option menu.

    then search for PowerCommands and select and install it from the list.

    image

    once the installation is done, click on tools then click on option menu.

    image

     

    from the options dialog box select PowerCommands and in the left hand side check the options you desire.

    image

     

    and you are good to go.

    Written by vahid

    Wednesday, May 30, 2012 at 1:51 PM

    Tagged with ,

  • SQL syntax formatter

    1436 comments

    Well it’s really pity that neither VS2010 nor SQL development studio provide SQL syntax formatter. but anyway there good news is that there are sites like http://www.tsqltidy.com  out there which would this for you for free.

    but that was not enough for me. i wanted to have tool with me to do this even when i am not connected to the internet–although does not happen that often Winking smile -

    Since i use Notepad++ as my text editor, i tought there might be a plug in for it. so searching online i found T-SQL formatter plug in.

    it’s not still a perfect formatter but in almost 90% of the times it’s done a great job for me.

    so if you also need a SQL formatter you may want to try this.

    To install it, open Notepad++, click on Plugins Menu and from the Plugin Manager menu click on Mange Plugins sub menu.

    image

    then from the Plugin Manager dialog box, select Poor Man’s T_Sql Formatter can click on install

    image

    it will ask you to restart the application click yes and next time you run Notepad++ you’ll have good SQL formatter plugin installed:

    image

    Written by vahid

    Friday, March 16, 2012 at 3:27 PM

    Tagged with ,