DBA dissappointed in sql server 2005

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.Charles,
I think you'll have much better response in the SQL Server 2005 newsgroups
... please re-post there:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
"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.|||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.|||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.|||Hi
Send your resqlwish@.microsoft.com
Yes, some of those features are nice, but
"Charles Pritt" wrote:
> 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.|||Charles,
Sounds as though you should have been at PASS 2004 last week. You could have
raised your concerns directly with MS managers there.
Chris Wood
Alberta Department of Energy
CANADA
"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.|||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.
>
>|||I thought that the address was sqlwish@.microsoft.com
Keith
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9E19AE0D-65B3-4006-BE6F-1F533EED69F4@.microsoft.com...
> Hi
> Send your resqlwish@.microsoft.com
> Yes, some of those features are nice, but
> "Charles Pritt" wrote:
> > 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.|||I wish I could have been there, but like a lot of companies, my company
doesn't have money for that sort of thing. And I am the only sql server dba
so it is difficult to get away.
not meaning to be antogonistic, just wondering if everyday management task
that comprises 90% to 95% of my workload has improved.
thanks for the reply.
"Chris Wood" wrote:
> Charles,
> Sounds as though you should have been at PASS 2004 last week. You could have
> raised your concerns directly with MS managers there.
> Chris Wood
> Alberta Department of Energy
> CANADA
> "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.
>
>|||There are other tools to manager db servers on an enterprise basis.
DBArtisan is one (note - I have no actual experience with this tool but it
was used by a fomer employer). My guess is that there are others.
"Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in message
news:DF22EB88-A335-4A9C-A1A4-5B548E77622E@.microsoft.com...
> I wish I could have been there, but like a lot of companies, my company
> doesn't have money for that sort of thing. And I am the only sql server
dba
> so it is difficult to get away.
> not meaning to be antogonistic, just wondering if everyday management task
> that comprises 90% to 95% of my workload has improved.
> thanks for the reply.
> "Chris Wood" wrote:
> > Charles,
> >
> > Sounds as though you should have been at PASS 2004 last week. You could
have
> > raised your concerns directly with MS managers there.
> >
> > Chris Wood
> > Alberta Department of Energy
> > CANADA
> >
> > "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.
> >
> >
> >|||Scott,
White Sands say this will be MS SQL ready later this year, at least at PASS
they said this.
Chris
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23LGfKYvqEHA.2696@.TK2MSFTNGP15.phx.gbl...
> There are other tools to manager db servers on an enterprise basis.
> DBArtisan is one (note - I have no actual experience with this tool but it
> was used by a fomer employer). My guess is that there are others.
> "Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in message
> news:DF22EB88-A335-4A9C-A1A4-5B548E77622E@.microsoft.com...
> > I wish I could have been there, but like a lot of companies, my company
> > doesn't have money for that sort of thing. And I am the only sql server
> dba
> > so it is difficult to get away.
> >
> > not meaning to be antogonistic, just wondering if everyday management
task
> > that comprises 90% to 95% of my workload has improved.
> >
> > thanks for the reply.
> >
> > "Chris Wood" wrote:
> >
> > > Charles,
> > >
> > > Sounds as though you should have been at PASS 2004 last week. You
could
> have
> > > raised your concerns directly with MS managers there.
> > >
> > > Chris Wood
> > > Alberta Department of Energy
> > > CANADA
> > >
> > > "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.
> > >
> > >
> > >
>|||I have DBArtisan. It is just a clone of sql enterprise manager. It allows the
administration of both sql server and oracle with the same tool.
thanks
"Scott Morris" wrote:
> There are other tools to manager db servers on an enterprise basis.
> DBArtisan is one (note - I have no actual experience with this tool but it
> was used by a fomer employer). My guess is that there are others.
> "Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in message
> news:DF22EB88-A335-4A9C-A1A4-5B548E77622E@.microsoft.com...
> > I wish I could have been there, but like a lot of companies, my company
> > doesn't have money for that sort of thing. And I am the only sql server
> dba
> > so it is difficult to get away.
> >
> > not meaning to be antogonistic, just wondering if everyday management task
> > that comprises 90% to 95% of my workload has improved.
> >
> > thanks for the reply.
> >
> > "Chris Wood" wrote:
> >
> > > Charles,
> > >
> > > Sounds as though you should have been at PASS 2004 last week. You could
> have
> > > raised your concerns directly with MS managers there.
> > >
> > > Chris Wood
> > > Alberta Department of Energy
> > > CANADA
> > >
> > > "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.
> > >
> > >
> > >
>
>|||There are others. CA has a tool. BMC has a tool. These were found with a
simple google search on enterprise database management.
"Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in message
news:D11AAF30-DE80-41B0-9B18-28BDBCB2C654@.microsoft.com...
> I have DBArtisan. It is just a clone of sql enterprise manager. It allows
the
> administration of both sql server and oracle with the same tool.
> thanks
> "Scott Morris" wrote:
> > There are other tools to manager db servers on an enterprise basis.
> > DBArtisan is one (note - I have no actual experience with this tool but
it
> > was used by a fomer employer). My guess is that there are others.
> >
> > "Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in
message
> > news:DF22EB88-A335-4A9C-A1A4-5B548E77622E@.microsoft.com...
> > > I wish I could have been there, but like a lot of companies, my
company
> > > doesn't have money for that sort of thing. And I am the only sql
server
> > dba
> > > so it is difficult to get away.
> > >
> > > not meaning to be antogonistic, just wondering if everyday management
task
> > > that comprises 90% to 95% of my workload has improved.
> > >
> > > thanks for the reply.
> > >
> > > "Chris Wood" wrote:
> > >
> > > > Charles,
> > > >
> > > > Sounds as though you should have been at PASS 2004 last week. You
could
> > have
> > > > raised your concerns directly with MS managers there.
> > > >
> > > > Chris Wood
> > > > Alberta Department of Energy
> > > > CANADA
> > > >
> > > > "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.
> > > >
> > > >
> > > >
> >
> >
> >|||2) In Enterprise Manager, open the properties for the login and check "Deny
Access". Or use sp_denylogin. That's for NT logins only though. For SQL
logins things are indeed less simple, although if you have your users in
roles, you can simply remove the user from the role temporarily.
3 & 4) If you organise your users in roles, you won't have that issue. You
only have to make sure that the roles exists on both databases. Or you can
just choose not to copy object-level permissions (disable "Use default
option" in the DTS Export Wizard and click the "Options..." button.
5) See the topics "Multiserver administration" and "Automating
administrative tasks" in Books Online.
Btw, about 1: why do you need compressed backups? Tape drives have built-in
compression and if you back up to disk you can back up to a compressed
folder under most circumstances.
--
Jacco Schalkwijk
SQL Server MVP
"Charles Pritt" <CharlesPritt@.discussions.microsoft.com> wrote in message
news:56F4AFBA-6A89-4FF1-99A1-35358C02A57A@.microsoft.com...
> 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.
>>sql