MS SQL Server 7.0

1
MS SQL Server 7.0
Project Demo by Amritaputra
Bhattacharya Avik Sarkar Kaushik
Das Srijit Maiti
2
Introduction to SQL Server 7.0

• A relational database management system
• Microsofts answer to Oracle
• Released in 99, moves software into the
  enterprise database arena
• Completely written in Microsoft code

3
Whats new in SQL Server 7.0

• Dynamic Self-Management
• Wizard-based Management tools
• Graphical Query Analyzer
• Windows 9x Support
• Improved Very Large Database Support
• Data Warehousing and Data Transformation Systems
• Microsoft English Query

4

• The enhancements to SQL Server 7.0 was
• primarily focussed on
• ease of use
• scalability
• data warehousing

5
Dynamic Self-Management
- eliminates the need to pre-allocate a given
amount of NTs memory and disk space for
SQL Server - SQL Server 7.0 is able to
automatically increase and decrease the
amount of memory and disk space required
6
Wizard-based Management tools
- SQL Server 7.0 introduces a set of new
administrative wizards to help perform many of
the common database management tasks. -
Replace the need to rely extensively on stored
procedures. - Primarily designed to help the new
SQL Server administrator to be immediately
productive. - Enable experienced administrator
to quickly perform common tasks
7
Graphical Query Analyzer
- allows you to type in SQL statements and
immediately see the results of those
statements. - has the ability to graphically
show the different steps that SQL Server uses
to process a query. -information provided by
Graphical Query Analyzer helps to determine how
to optimize the queries and whether the queries
will benefit by creating indices.
8
Windows 9x Support
- A major enhancement of SQL Server 7.0 is its
support for WINDOWS 95 and 98. - Support for
Windows 9x allows SQL Server applications to
be scaled down to single desktop, as well as
into small branch-office scenario.
9
Improved Very Large Database
- New High performance online backup -
Introduction of incremental database backup and
restore features.
10
Data Warehousing and Data Transformation System
Query engine has been redesigned to better
handle complicated queries required by Decision
Support System (DSS) .
Improved query support for the new Micro Soft
OLAP services.
New Data Transformation Services (DTS) to
facilitate transfer of data between SQL server
and other databases...
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
Databases

• Each SQL Server contains multiple databases,
  where
• each database is maintained in one or more
  operating
• system (OS) files.
• The databases are
• master database
• model database
• msdb database
• temp database
• pubs database
• Northwind database

15
SQL Server Administration

• Backup Recovery
• Database Maintenance
• Alerts

16
Backup Recovery

• Why backup the Database ?
• Assuming
• Power failure that causes system to halt
• Hardware failure
• Software failure
• Application error
• Mistake by user

17
Database Recovery
Situations which require database recovery
are SQL Server terminate abnormally in the
middle of a transaction having a poten- tially
inconsistent , but undamaged database.
18
Database Maintenance
SQL Server has a database maintenance plan wizard
to simplify the setup of scheduled jobs for
backup and other operations.