Extending Management Studio

In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management Studio. If ISVs (independent software vendors) could plug their SQL Server tool(s) into Management Studio – creating a single environment for you to work in – which tools do you use that you’d like to see surfaced in Management Studio.

Dan

DBGhost by Innovartis.

It would be extremely nice to be able to compile, check in, and check out changes on the fly from within SQLMS.

Also, IntelliSense would be very nice. Apex SQL Edit has their own, however I like the VS / SQLMS interface better.|||Thanks for the feedback. IntelliSense is soemthing we're looking into. A different group owns this so I don't know the latest for it. Its addition would improve greatly productivity.

Dan|||RedGates SQL Compare and Data Compare tools would be very helpful for those of us that manage seperate Dev, UAT and Production enviroments.

Allison|||Could we get the Query Analyzer from SS 2000?
Please.|||Sessionless analysis of current operations available in Quest's Spotlight. It was explained to me as directly analysing the memory (whitesapaces) being used by SQL Server.|||G'day Dan.

Are you asking which elements of the Management Studio we would like to see exposed to extensibility? If so, I have a list! ;-) I am an ISV start-up with a potentially "killer app" (aren't they all lol) and the lack of extensibility is crippling...
Cheers,

Paul McMahon
Xavier Ltd|||Hi Paul,

That's a slightly different question than what I'm asking, however, it is very relevant. Let's chat as I'd love to get your list - you can reach me at dan.jones@.microsoft.com.

Cheers,
Dan|||I think it would be cool to have PromptSQL integrated into Management Studio to give SQL Intellisense inside Management Studio :-)

But then I would say that.|||With respect to QA 2000, what is lacking in SSMS 2005 that you would want added?

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform Team
Red Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>
|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:

> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you to
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
sql

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio ? creating a single environment for you to
work in ? which tools do you use that you?d like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else :)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>> Hi There,
>> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
>> Management
>> Studio. If ISVs (independent software vendors) could plug their SQL
>> Server
>> tool(s) into Management Studio - creating a single environment for you to
>> work in - which tools do you use that you'd like to see surfaced in
>> Management Studio.
>> Cheers,
>> Dan
>> Lead PM
>> SQL Server Management Platform Team
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio â' creating a single environment for you to
> work in â' which tools do you use that youâ'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managemen
t
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:

> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managem
ent
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you t
o
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>