1 / 16

Sql Server Advanced Features

Sql Server Advanced Features. MIS 424 Professor Sandvig. Outline. Sql Server Management Studio Security Programmability Example. Caveat. Sql Server very complex & feature-rich product Many features not discussed Focus on “developer” features. Database Admin.

anoush
Download Presentation

Sql Server Advanced Features

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. Sql Server Advanced Features MIS 424 Professor Sandvig

  2. Outline • Sql Server Management Studio • Security • Programmability • Example

  3. Caveat • Sql Server very complex & feature-rich product • Many features not discussed • Focus on “developer” features

  4. Database Admin

  5. SQL Server Management Studio • Provides interface to Sql Server • More features than Visual Studio • Security • Users & permissions • Programmability • Diagrams • Relationships • Optimization

  6. SQL Server Management Studio • Features: Visual Studio vs. SQMS

  7. Security • Authentication & Authorization • Security is two step process: • Authentication: • Identifying user • Username & password • Authorization: • Check permissions for specific actions: • Select, insert, update, delete…

  8. Authentication • Sql Server supports: • Windows Authentication • Sql Server Authentication

  9. Windows Authentication • User identified by Windows OS • Windows prompt • Advantage: use existingWindows login • Manyorganizations use Active Directory

  10. Sql Server Authentication • User created on SQL Server • Sql Server manages username/password • Benefit: • Can create specialized users with limited permissions • Example: ZipCodeReader

  11. Authorization • Every request must be authorized • Common methods: • Create limited user • ZipCodeReader • Anonymous user: • Web site • Network Service • Account • Built-in Windowsacct

  12. SQL Server Authorization • SQL Server allows granular control: • Tables • Fields • Stored procedures

  13. Programmability • Store queries on database • Reuse in many applications • Division of duties • Devs & DBAs • Security options • Hide underlying tables

  14. Programmability • Stored procedures • Store query on database • Accept arguments • Assign permissions to procedure • T-Sql supports complex queries • CRUD support

  15. Programmability • Functions • Read only • Support input parameters • Utilized inside sql statements: Select * FROM funGetNames Where NameF LIKE ‘s%’ Order by NameL • May use in other functions, SPs, SQL queries

  16. Example: • Sql Server Management Studio: • Create database • Add table • Create user • Add user permissions to database

More Related