Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jul 2, 1998

SQL 7 Preview from TechEd '98

By Sharon Dooley

This session focused on the 'ease of use' release theme. The presenter stated that people are buying 2 to 300 copies of SQL Server at a time. Microsoft's goal is to move out of the workgroup niche and have SQL Server on the desktop and in large organizations.

For the desktop, they want to have SQL Server self-configuring, with no DBA requirement. For workgroups, they want it to be self-managing. For large organizations, they want the lowest total cost of ownership, to support multi-server operations and to provide interoperability. There will be 20 Wizards in Beta3, 5-10 more by ship date.

For the DBA, they are providing a data base designer This is basically the Visual Database Tools diagrammer. It is not a full-blown data modeling tool like ERWin or System Architect. There was a demo of the database diagrammer. It will be possible to print the database diagrams by release; right now it isn't. SQL Trace has been renamed SQL Profiler and is much enhanced. The Index Tuning Wizard is almost frightening, but since it doesn't handle concurrency issues I don't think I'll be out of work yet! A functioning (unlike previous efforts) graphical showplan is available and it is really good. Shows the costing info and decision process clause by clause.

For data warehousing, they are providing the Data Transformation Services, the Microsoft Repository, which will be part of SQL Server, and Microsoft English Query. (More on both of these later.)

Distributed Management Framework and DMO

For ISV's and MIS Applications, they are going to make it easy to embed and deploy SQL Server. SQL-DMO provides a COM administrative interface. There is something called the SQL-namespace which I don't completely understand. It is composed of administration objects and the administration UI. You are supposed to be able to put specific dialogues or wizards into any tool that supports SQL Server. I don't know how to do his yet, but it would clearly solve some of the problems of presenting some but not all functions to a power user who isn't a full-fledged administrator.

The new Distributed Management Framework looks like this:

You will be able to use VB to launch a wizard, as well. The events layer is used by the SQL Profiler, which allows it to see "inside", stored procedures (the current SQL Trace only shows you the exec statement for the procedure). Things like table scans and locks will also be events. I assume this means we might be able to set up alerts for a table scan of a big table but I don't know for sure.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM