| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1016505
|
| Doc. No
|
:
|
b770875
|
| Main Entry
|
:
|
Ericsson, Robert.
|
| Title & Author
|
:
|
SQL Server 2005 for developers /\ Robert Ericsson, Jason Cline.
|
| Edition Statement
|
:
|
1st ed.
|
| Publication Statement
|
:
|
Boston, Mass. :: Charles River Media,, ©2007.
|
| Series Statement
|
:
|
Charles River Media programming series
|
| Page. NO
|
:
|
1 online resource (x, 405 pages) :: illustrations.
|
| ISBN
|
:
|
1584503882
|
|
|
:
|
: 1584506598
|
|
|
:
|
: 9781584503880
|
|
|
:
|
: 9781584506591
|
|
|
:
|
1584503882
|
| Bibliographies/Indexes
|
:
|
Includes bibliographical references (page 393) and index.
|
| Contents
|
:
|
""Contents""; ""1 Introduction""; ""What is SQL Server?""; ""SQL Server History""; ""What is in this Book?""; ""2 Database Design""; ""Informal Rules of Database Design""; ""Normalization""; ""Design Process""; ""Design of Example Application""; ""Conclusion""; ""3 Database Security""; ""Access Control""; ""Security Analysis""; ""SQL Server Security Design Principles""; ""SQL Server 2005 Security Model""; ""SQL Server 2005 Security Features Authentication Modes""; ""Encryption""; ""User and Schema Separation""; ""Execution Context""; ""Signed Modules""; ""Password Policy Enforcement""
|
|
|
:
|
""12 Data Warehouse""""Top-Down versus Bottom-Up""; ""Data Warehouse versus Transactional Systems""; ""Dimensional Modeling""; ""Sizing of a Data Warehouse""; ""Data Preparation and Cleansing""; ""Loading Data""; ""Conclusion""; ""13 SQL Server Integration Services""; ""DTS Packages""; ""Containers""; ""Workflow""; ""Event Handlers""; ""Data Flow""; ""Variables""; ""Expressions""; ""Logging""; ""SQL Server Import/Export Wizard""; ""Designer""; ""Conclusion""; ""14 SQL Server Reporting Services""; ""Reporting""; ""Report Design""; ""Reporting Services Architecture""; ""Conclusion""
|
|
|
:
|
""15 OLAP""""Introduction to Analysis Services""; ""OLAP Basics""; ""The Unified Dimensional Model""; ""Analysis Services Architecture""; ""MDX""; ""MDX Scripts""; ""Example""; ""Conclusion""; ""16 Introduction to Data Mining in SSAS 2005""; ""Data Mining Fundamentals""; ""Conclusion""; ""References""; ""About the CD-ROM""; ""Index""; ""A""; ""B""; ""C""; ""D""; ""E""; ""F""; ""G""; ""H""; ""I""; ""J""; ""K""; ""L""; ""M""; ""N""; ""O""; ""P""; ""Q""; ""R""; ""S""; ""T""; ""U""; ""V""; ""W""; ""X""
|
|
|
:
|
""Management and Operations""""Conclusion""; ""8 XML in SQL Server 2005""; ""XML Basics""; ""Native Storage for XML""; ""XML Query""; ""SQL Server Native Web Services""; ""Conclusion""; ""9 Service Broker""; ""Asynchronous Queuing""; ""Programming Model""; ""Service Broker Security""; ""Conclusion""; ""10 Performance Analysis and Tuning""; ""A Journey, Not a Destination""; ""Performance Factors""; ""Tools""; ""Conclusion""; ""11 Business Intelligence""; ""Challenges""; ""Providing Value""; ""Delivering Value""; ""SQL Server 2005 Business Intelligence Features""; ""Conclusion""
|
|
|
:
|
""Row-Level Security""""Granular Permissions""; ""Catalog Security""; ""SQL Server 2005 Security Best Practices""; ""Conclusion""; ""4 Transact-SQL for Developers""; ""Syntax Elements""; ""Basic Statements""; ""Additional Transact-SQL Language Enhancements""; ""Conclusion""; ""5 Programmability""; ""Assemblies""; ""User-Defined Types""; ""Stored Procedures""; ""User-Defined Functions""; ""Triggers""; ""Aggregates""; ""Conclusion""; ""6 ADO.NET 2.0""; ""New ADO.NET 2.0 Features""; ""Conclusion""; ""7 Notification Services""; ""Introducting Notifications""; ""Notification Applications""
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
Relational databases.
|
| Subject
|
:
|
Architecture client-serveur (Informatique)
|
| Subject
|
:
|
Bases de données relationnelles.
|
| Subject
|
:
|
SQL Server.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
REFERENCE-- General.
|
| Subject
|
:
|
Relational databases.
|
| Subject
|
:
|
SQL server.
|
|
|
:
|
SQL server.
|
| Dewey Classification
|
:
|
005.2/768
|
| LC Classification
|
:
|
QA76.9.C55E75 2007eb
|
| Added Entry
|
:
|
Cline, Jason.
|