Re: DBA dissappointed in sql server 2005

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 09:52:05 -0400

http://www.aspfaq.com/sql2005/show.asp?id=1 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Charles Pritt" <Charles Pritt@discussions.microsoft.com> wrote in message
news:0255B038-53EE-43C9-A64E-BEB4D45EAFE0@microsoft.com...
> I've been looking at the beta2 release of yukon and I am beginning to be
> dissappointed in the product from a DBA viewpoint. I realize that a lot of
> improvements have been made in the programmers side of things, but I still
> have to manage the sql servers and I do not see any improvements in my day
to
> day, week to week regular management task I have to perform. For instance:
>
> 1.) i do not see any option to tell a backup to compress the backup file
as
> it backsup a database. this would be a highly desired feature.
>
> 2.) there is no way to temporarily disable logins without changing the
> persons password which is not desired.
>
> 3.) using dts to export a table from a "development" database to a
"testing"
> or "production" database will only move the table definition and data, but
> not the underlying indexes or constraints.
>
> 4.) using dts to export a view will only create a table on the recieving
> end, not a view.
>
> 5.) I have 75 seperate sql server boxes, some with multiple instance, all
> with many many databases and scores of jobs. I need something that can
show
> me easily the status of all jobs across all the servers without manually
> connecting to each individual sql server instance and then expanding down
to
> jobs. I want to select jobs and all jobs across all instance are shown
sorted
> by whatever I choose. Same way i want to select current processes and see
the
> same things.
>
> the list goes on....
>
> mayby others can enlighten me and point out some real benefits in the new
> sql server from a dba point of view.

Relevant Pages

  • Re: Delphi 5 + Win 2K
    ... > " If the database is cleaned up by deleting many jobs it seems to work ... It does not mean SQL server jobs... ... Tree.Items.SaveToFileand then put into the database using ...
    (borland.public.delphi.database.ado)
  • Re: db maintanence plan failure
    ... To be able to run DBCC CHECKDB with FAST_REPAIR, the database must be in single user mode, so if you ... Tibor Karaszi, SQL Server MVP ... >>> split into 2 seperate jobs when I look at the Jobs node under SQL Agent. ...
    (microsoft.public.sqlserver.server)
  • DBA dissappointed in sql server 2005
    ... dissappointed in the product from a DBA viewpoint. ... it backsup a database. ... I have 75 seperate sql server boxes, some with multiple instance, all ... with many many databases and scores of jobs. ...
    (microsoft.public.sqlserver.server)
  • Re: DBA dissappointed in sql server 2005
    ... are already available in SQL Server 2000. ... "Charles Pritt" wrote in message ... > it backsup a database. ... > with many many databases and scores of jobs. ...
    (microsoft.public.sqlserver.server)
  • Re: Delphi 5 + Win 2K
    ... " If the database is cleaned up by deleting many jobs it seems to work ... Do you mean SQL server jobs that are scheduled? ... What happens to the data if you take the compressed data in the component ...
    (borland.public.delphi.database.ado)