a better Enterprise Manager plz

hi,
do u know some nice (preferably commersial) tool for SQL Server 2k
administration
Embarcadero DBArtisan 8.0 (current).
"Coldman" wrote:

> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>
>
|||tnx, Julia, i`ll try it
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:01FAB6BB-7431-4F0D-9CE4-FFCD62BB2BD5@.microsoft.com...[vbcol=seagreen]
> Embarcadero DBArtisan 8.0 (current).
> "Coldman" wrote:
|||Hi,
DBArtsan is a good tool for Oracle/DB2 and Sybase. But as far as SQL Server
is concerned Enterprise manager is the best for
doing basic administration.
Thanks
Hari
SQL Server MVP
"Coldman" <nomorespam@.mail.com> wrote in message
news:OJbRR$KrFHA.2604@.TK2MSFTNGP14.phx.gbl...
> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>
sql

a better Enterprise Manager plz

hi,
do u know some nice (preferably commersial) tool for SQL Server 2k
administrationEmbarcadero DBArtisan 8.0 (current).
"Coldman" wrote:

> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>
>|||tnx, Julia, i`ll try it
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:01FAB6BB-7431-4F0D-9CE4-FFCD62BB2BD5@.microsoft.com...[vbcol=seagreen]
> Embarcadero DBArtisan 8.0 (current).
> "Coldman" wrote:
>|||Hi,
DBArtsan is a good tool for Oracle/DB2 and Sybase. But as far as SQL Server
is concerned Enterprise manager is the best for
doing basic administration.
Thanks
Hari
SQL Server MVP
"Coldman" <nomorespam@.mail.com> wrote in message
news:OJbRR$KrFHA.2604@.TK2MSFTNGP14.phx.gbl...
> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>

a better Enterprise Manager plz

hi,
do u know some nice (preferably commersial) tool for SQL Server 2k
administrationEmbarcadero DBArtisan 8.0 (current).
"Coldman" wrote:
> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>
>|||tnx, Julia, i`ll try it
"Julia" <Julia@.discussions.microsoft.com> wrote in message
news:01FAB6BB-7431-4F0D-9CE4-FFCD62BB2BD5@.microsoft.com...
> Embarcadero DBArtisan 8.0 (current).
> "Coldman" wrote:
>> hi,
>> do u know some nice (preferably commersial) tool for SQL Server 2k
>> administration
>>|||Hi,
DBArtsan is a good tool for Oracle/DB2 and Sybase. But as far as SQL Server
is concerned Enterprise manager is the best for
doing basic administration.
Thanks
Hari
SQL Server MVP
"Coldman" <nomorespam@.mail.com> wrote in message
news:OJbRR$KrFHA.2604@.TK2MSFTNGP14.phx.gbl...
> hi,
> do u know some nice (preferably commersial) tool for SQL Server 2k
> administration
>

3rd party tools for job scheduling

I am looking for a better way to schedule jobs in SQL Server. I found
this tool called SQLschedule at www.idera.com and am using the 30 day
trial. This tool really has a cool GUI, and seems to work well. Does
anyone else have any experience with their tools?Are you aware of SQL Server's own Agent? What functionality are you looking
for that Agent doesn't provide?

--
David Portas
SQL Server MVP
--

3rd party tool to create reports

Hi,
Does any one know of a 3rd party tool to create report definitions for SQL
Reporting Services so you don't have to use Visual Studio.NET?
Y/JakobUnless you have objections about how it creates it or how easy it is to
create it, all you need to have is any version of VS, which includes VB. I
believe it is possible to get something with VS that costs only $100. I
doubt you could purchase a report writer for less than that. $100 per
developer is pretty inexpensive.
Bruce L-C
"Jakob Olsen" <jaoss@.wmdata.com> wrote in message
news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Does any one know of a 3rd party tool to create report definitions for SQL
> Reporting Services so you don't have to use Visual Studio.NET?
> Y/Jakob
>|||There are some 3rd party tools listed at
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23C5JSLElEHA.592@.TK2MSFTNGP11.phx.gbl...
> Unless you have objections about how it creates it or how easy it is to
> create it, all you need to have is any version of VS, which includes VB. I
> believe it is possible to get something with VS that costs only $100. I
> doubt you could purchase a report writer for less than that. $100 per
> developer is pretty inexpensive.
> Bruce L-C
> "Jakob Olsen" <jaoss@.wmdata.com> wrote in message
> news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Does any one know of a 3rd party tool to create report definitions for
>> SQL Reporting Services so you don't have to use Visual Studio.NET?
>> Y/Jakob
>

3rd Party Performance Tool/Software

Is there any software that can analyze stored procedure performance and
recommend solutions?
Thanks,
Dave
How about the database engine tuning advisor, which ships with the product?
You can send it a workload consisting of a single stored procedure call, but
for a better analysis and set of recommended enhancements, you're better off
providing a workload of a typical business day.
Note that this tool will recommend structural changes like adding/removing
indexes, partitioning, etc. It will not look at your SELECT query with 18
unions and suggest a single FROM with a CASE expression. :-)
A
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave
|||As far as I am aware, there is no tool that would take a stored procedure,
optimize and refactor it, and recommend alternative solutions.
The only 'tool' that can do that is a skilled DBA!!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave
|||InDepth for SQL Server has such a feature which it implements by levaraging
either ITW or DTA depending on SQL version. It uses performance data stored
in its Performance Warehouse to feed the recommendations. It also clearly
identifies the statements and batches that are consuming most resource to
help guide your tuning efforts. To be honest we mostly use it for the latter
as it's extremely light weight and much less resource intensive than a trace
plus we don't want ITW/DTA run against a production database. However by
identifying the main resource consumers these can be tuned and measured in
the QA envionment to produce recommendations for production.
http://www.symantec.com/enterprise/products/overview.jsp?pcid=1021&pvid=317_1
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"David" <nospam@.home.com> wrote in message
news:216B98B9-8D9B-4143-A12C-810B24CD2723@.microsoft.com...
> Is there any software that can analyze stored procedure performance and
> recommend solutions?
> Thanks,
> Dave

3rd party Data Administration Tools

I'm looking for a 3rd party tool to manage
disabling/enabling triggers. I evaluated Teratraw
Database Manager and it easily allows disabling/enabling
triggers via the gui but only 1 trigger at a time. I need
a tool that can disable/enable ALL triggers in a database
easily. (Similar to TOAD for Oracle).
Anyone know of such a management tool?
Thanks Rich
SQLExecMS from www.laplas-soft.com will help you
"Rich" <rstoll@.cadencenet.com> wrote in message
news:1c5701c5317f$dc1023a0$a601280a@.phx.gbl...
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
|||Would a stored procedure work for you?
"Rich" wrote:

> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>
|||
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
|||Hello Rich,
TOAD for SQL Server is currently in freeware (http://www.toadsoft.com/toadsqlserve..._sqlserver.htm), but a -much- more feature-laden version will go into beta in June. Take a look at the current version and stay on the lookout for the beta announceme
nt for the big summer release.
Hope this helps,
-Kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> I'm looking for a 3rd party tool to manage disabling/enabling
> triggers. I evaluated Teratraw Database Manager and it easily allows
> disabling/enabling triggers via the gui but only 1 trigger at a time.
> I need a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>