1 / 41

Administering and Implementing Microsoft SQL 2005

This training course covers the features, installation, configuration, database creation and management, and security of Microsoft SQL 2005. It also includes topics on automated tasks and database backup.

lewisjennifer
Download Presentation

Administering and Implementing Microsoft SQL 2005

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. Administering and Implementing Microsoft SQL 2005 Chokchai Junchey Microsoft Product Specialist Certified Technical Training Center

  2. Agenda • Overview SQL 2005 Features • Installing Microsoft SQL 2005 • Configuring SQL 2005 • Create and Manage 2005 Database

  3. Overview Microsoft SQL 2005 Features

  4. SQL 2005 Components • Database Engine • Analysis Service • Reporting Service • Integration Service • Notification Service

  5. SQL Database Engine • New data type, XML and varchar(max) • Snapshot isolation • Native XML Web Service • Service Broker Support • Include Index • Online Restore • Partitioning

  6. Analysis Service • Support Multi-dimentional Database • Multiple fact-table • Advanced Data mining • UDM Support

  7. Reporting Service • Support Web and Windows • Matrix, Table, Chart and Free form • Subscription Support • .NET Function Plug-in • Export to Excel, PDF and more

  8. Integration Service • Transfer data from one system to another • Built-in more functions • Scheduling Support • Built-in fuzzy logic

  9. Notification Service • Monitoring File System and Table • Response when data match • Mail and File response support

  10. SQL Editions • Express • Workgroup • Standard • Enterprise • Developer • Mobile

  11. SQL Express Edition • 1 Processor Supports • 1 GB Memory • 4 GB Database • Database Engine and Reporting Service

  12. SQL Workgroup Edition • 2 CPU • 3 GB Memory • Unlimited Database Size • Database Engine and Reporting

  13. Standard Edition • 32 Bits and 64 Bits supported • 4 CPU • Unlimited Memory Support • All Components • Clustered Support (2 Nodes)

  14. Enterprise Edition • 32 Bits and 64 Bits • Unlimited CPU Support • Unlimited Memory Support • All Components • Clustered Support ( > 2 Nodes) • Online Operation Support (Index, Restore)

  15. Installing SQL 2005

  16. Understanding SQL 2005 Architecture • Instance • Collation

  17. SQL Instance • Virtual SQL Server • Control CPU and Memory Usage • Different Configuration

  18. SQL Collation • Character Set • Sort Order

  19. Configuring SQL 2005

  20. Configuration Options • Network Configuration • CPU Configuration • Memory Configuration • Database Configuration

  21. Network Configuration • SQL Surface Area Configuration • SQL Configuration Manager

  22. CPU Options • Limited CPU Usage • Fiber Mode • Worker Thread • Priority Control

  23. Memory Options • Limited Memory Usage for SQL • Add /3GB to Increase SQL Memory to 3 GB • Add /PAE and AWE

  24. Manage SQL 2005 Database

  25. Creating SQL 2005 Database • Prepare More Than One Physical Disk • Format Disk using 8K or 16K Clustered Block

  26. File Group and File • Use Multiple Filegroup to Speed Up Index on Join • Use Multiple File to Speed Up Single Table

  27. SQL Database Options • Recovery Option • Compatible Option • Statistics • Database State

  28. Manage SQL Database • Expand Database Size • Shrink Database Size • Create SQL Partition

  29. Manage SQL Server Security

  30. SQL 2005 Authentication • Windows Authentication • SQL Authentication • Asymmetric Key • Certificates Authentication

  31. SQL Permission • Principal • Permission • Securable

  32. Logins and Users • Logins use to connect to SQL Server • Users map Login to Databases

  33. Database Roles • Standard Database Roles • Application Roles

  34. Automated Task

  35. Overview Automated Task • SQL Agent and Event Log • Alert • Jobs • Operator

  36. Alerts • Event Alert • Performance Alert • WMI Alert

  37. Operators • Response to SQL Alert or Jobs • Mail Recipient • Windows Message • Fax Email

  38. Backing UP Database

  39. Overview SQL Backup • Using VSS Features on Windows 2003 • Using SQL Backup

  40. Backup Type • Data Backup • Full Backup • Differential Backup • Log Backup

  41. Backup Options • Media Name and Password • Mirror and Parallel Backup • Init and Format • Expire dates

More Related