How can we improve SQL Prompt?

Support for PDW (Parallel Data Warehouse, aka APS)

Work at a company where we're adopting PDW. It would be great if I could get intellisense in PDW.

58 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike Fulkerson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    13 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • AdminAaron Law (Software Engineer, Redgate) commented  ·   ·  Flag as inappropriate

        Hi Anthony,

        For SQL Prompt 7.2 we're just focusing on implementing code suggestions when connected to PDW. Formatting PDW syntax seems like a logical next step but we haven't got any firm plans for when that'll happen.

      • Anthony Perkins commented  ·   ·  Flag as inappropriate

        Thank you. This is positively brilliant.

        Are there any plans to extend the functionality of "Format SQL" to support the APS/PDW SQL syntax?

        For example, currently you cannot use "Format SQL", if you use code like the following:
        create remote table MyMatabase.dbo.MyTable at ('Data Source = x.x.x.x; User ID = UserName; Password = MyPassword') as
        ...

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi, is there any feedback regarding this? Is PDW support an option in the near future?

      • Anonymous commented  ·   ·  Flag as inappropriate

        I understand that there is no intellisense in PDW yet. But is there any third party tools that I can use?

      • Ken Boone commented  ·   ·  Flag as inappropriate

        Agreed, Chris. I didn't realize how much I relied on SQL Prompt until I lost it working with PDW.

      Feedback and Knowledge Base