Re: DBA dissappointed in sql server 2005

From: Charles Pritt (CharlesPritt_at_discussions.microsoft.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 08:07:03 -0700

Please explain how number 2) already exist in current product.

For number 3 and 4) if you are referring to having the dts wizard export an
object and then selecting a specific table, I have not been able in the last
4 years to get this to work reliably. Mainly because there will always be
some user that has access to that object on the source side that doesn't
exist on the destination side and it fials because the specific users does
not exists on the destination. Also, I did not see the option to move a
"object" in the 2005 export wizard.

for number 5) if you are referring to having to register each individual sql
server and then clicking on each of the 75 sql servers one at a time and then
going down to mangement and then sql server agent and then jobs looking at
the list and then going to the next sql server agent and clicking on it and
then going to management. and so on.... I agree with you ... they have it.
that is the way i do it now. I am referring to clicking on a icon that says
sql server and then clicking on a icon that says jobs and it list every sql
server and every job and its status. two clicks. a couple minutes to see all
jobs.

no i have not been dissappointed in sql server 2000, it is a far cry from
sql server 6.5 and sql server 7.0 but there are still things lacking. This is
my job. it all i do everyday, 7 days a week. manage more than 75 sql server,
jobs, users, backups, and quite a few sql server clusters. I'm just looking
for some improvement in the day to day task I perform.

"Jacco Schalkwijk" wrote:

> You must have been disappointed in SQL Server 2000 as well then. 2, 3, 4 and
> 5 are already available in SQL Server 2000.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "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