Re: DBA dissappointed in sql server 2005

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 10:12:57 -0500

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.

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)