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/new...elcomePage.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 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...[vbcol=seagreen]
> Hi
> Send your resqlwish@.microsoft.com
> Yes, some of those features are nice, but
> "Charles Pritt" wrote:
of[vbcol=seagreen]
still[vbcol=seagreen]
day to[vbcol=seagreen]
instance:[vbcol=seagreen]
as[vbcol=seagreen]
"testing"[vbcol=seagreen]
but[vbcol=seagreen]
all[vbcol=seagreen]
show[vbcol=seagreen]
down to[vbcol=seagreen]
sorted[vbcol=seagreen]
see the[vbcol=seagreen]
new[vbcol=seagreen]
|||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...
> to
> as
> "testing"
> show
> to
> sorted
> the
>
>
|||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[vbcol=seagreen]
> 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:
have[vbcol=seagreen]
message[vbcol=seagreen]
be[vbcol=seagreen]
lot of[vbcol=seagreen]
still[vbcol=seagreen]
day[vbcol=seagreen]
instance:[vbcol=seagreen]
file[vbcol=seagreen]
but[vbcol=seagreen]
recieving[vbcol=seagreen]
all[vbcol=seagreen]
manually[vbcol=seagreen]
down[vbcol=seagreen]
see[vbcol=seagreen]
new[vbcol=seagreen]