Flylib.com
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115
Authors:
Solid Quality Learning
BUY ON AMAZON
Microsoft SQL Server 2005: Applied Techniques Step by Step
Table of Contents
Copyright
Introduction
Acknowledgments
Part I: How to Create a SQL Server Database to Store Your Application Data
Chapter 1. Choosing Which Application Data to Store in Your Database
Where to Store Application Settings
Where to Store User Settings
Where to Store XML Documents
Where to Store External Application Files
Conclusion
Chapter 2. Basic Database Security Principles
Designing Network Security to Secure Your Database System
Managing Access to SQL Server Instances
Managing Access to SQL Server Databases
Managing Access to Schemas
Managing Access to Tables and Columns
Managing Access to Programmable Objects
Conclusion
Chapter 3. Disaster Recovery Techniques to Protect Your Database
Using Full Database Backups
Using Differential Backups
Using Transaction Log Backups
Recovering a Database
Scheduling Backups Using the SQL Maintenance Plan Wizard
Conclusion
Chapter 4. Transferring Your Database to Other Systems
Using Backup and Restore to Transfer Your Data
Using Detach and Attach to Transfer Your Data
Using Replication to Transfer Your Data
Using SSIS to Transfer Your Data
Automating and Scheduling the Transfer of Your Data
Conclusion
Part II: How to Query Data from SQL Server
Chapter 5. Computing Aggregates
Counting Rows
Computing Totals and Subtotals
Computing Running Totals
Computing Statistical Values
Designing Your Own User-Defined Aggregates Using the CLR
Conclusion
Chapter 6. Improving Query Performance
Understanding Query Plans
Creating Indexes to Provide Faster Query Execution
Tuning Queries Using the Database Engine Tuning Advisor
Conclusion
Chapter 7. Building Queries Dynamically
A User Interface for Building Queries
Retrieving Information about the Tables in a Database
Sorting and Filtering Dynamically
Parameters and Security in Dynamic Queries
Conclusion
Chapter 8. Working with Data from Remote Data Sources
Reading Data from Remote Sources at the Middle Tier
Reading Data from Remote Sources in SQL Server
Inserting, Updating, or Deleting Data from Remote Sources in SQL Server
Conclusion
Chapter 9. Reading SQL Server Data from the Internet
Direct Access to SQL Server
Interoperability with Other Systems through HTTP Endpoints
Access to SQL Server through an Extra Layer
Conclusion
Part III: How to Modify Data in SQL Server
Chapter 10. Using Transactions to Provide Safe Database Concurrency
Business Transactions and SQL Server Transactions
Defining Transactions in SQL Server
Managing Transaction Isolation
Transactions in ADO.NET
Conclusion
Chapter 11. Keeping History Data
Taking a Snapshot of Your Database
Summarizing Data in History Tables
Summarizing Data in Indexed Views
Tracking Changes Using Audit Columns and Audit Tables
Conclusion
Chapter 12. Introduction to Reporting Services
Requirements for a Reporting Solution
Design Considerations
Reporting Services Architecture
Creating a Basic Report
Conclusion
Chapter 13. Introduction to Notification Services
A Notification Services Scenario
Gathering Requirements
Building the Application
Running the Application
Conclusion
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
Y
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115
Authors:
Solid Quality Learning
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
Assessment Test
Other Planning Processes
Project Closure
Appendix A Systems Development Life Cycle
Appendix B Standard IT Project Documents
101 Microsoft Visual Basic .NET Applications
Working with Microsoft Visual Studio .NET 2003 and Microsoft .NET Framework 1.1
Interacting with the Operating System
Working with the .NET Framework
COM Interop/PInvoke
Coding Conventions
Mapping Hacks: Tips & Tools for Electronic Cartography
Hacks 1-13
Hack 1. Put a Map on It: Mapping Arbitrary Locations with Online Services
Hack 33. Georeference an Arbitrary Tourist Map
Hack 75. Share Your GRASS Maps with the World
Hack 83. Map Numerical Data the Easy Way
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Basic ImageReady Animation, Tweening, and Layer Styles
Photoshop Layers and After Effects
3-D Layers from Photoshop Layers
Static Matte Painting in Photoshop
Motion Titling Effects
File System Forensic Analysis
Data Analysis
BSD Partitions
Indexes
Journal Data Structures
Block and Fragment Bitmaps
Comparing, Designing, and Deploying VPNs
Designing and Deploying L2TPv3-Based Layer 2 VPNs
Review Questions
A Detailed Examination of MPLS Layer 3 VPNs
Scaling and Optimizing IPsec VPNs
Review Questions
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies