1 / 18

MS SQL Server 7.0

MS SQL Server 7.0. Project Demo by: Amritaputra Bhattacharya Avik Sarkar Kaushik Das Srijit Maiti. Introduction to SQL Server 7.0. A relational database management system Microsoft’s answer to Oracle Released in ‘99, moves software into the enterprise database arena

mbuffington
Download Presentation

MS SQL Server 7.0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 • Microsoft’s answer to Oracle • Released in ‘99, moves software into the enterprise database arena • Completely written in Microsoft code

  3. What’s 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 NT’s 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. 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

  12. SQL Server Administration • Backup & Recovery • Database Maintenance • Alerts

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

  14. 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.

  15. Database Maintenance SQL Server has a database maintenance plan wizard to simplify the setup of scheduled jobs for backup and other operations.

More Related