|
|
|
|
Portable and precise, this pocket-sized guide delivers
ready answers for administering SQL Server 2008 Release
2. Zero in on core support and maintenance tasks by using
quick-reference tables, instructions, and lists. You'll
get the focused information you need to solve problems
and get the job done-whether at your desk or in the
field. Get fast facts to: Plan, deploy, and configure
SQL Server 2008 R2. Administer server and surface
security, access, and network configuration. Import,
export, transform, and replicate data. Use SQL Server
Management Studio for core administrative tasks.
Manipulate schemas, tables, indexes, and views. Automate
maintenance and implement policy-based management.
Monitor server activity and tune performance. Manage log
shipping and database mirroring. Perform backups and
recovery.
|
| |
| ISBN: |
073562738X |
| ISBN-13: |
9780735627383 |
| Author: |
Stanek, William R. |
| Published: |
12/05/2010 |
| Availability: |
Order will be despatched within 24 hours |
| Price: |
$ 72.95 Inc GST |
| |
|
|
| © 2010 Microsoft Press Shop |
|
|
|
|
|
Get a detailed look at the internal architecture of T-SQL
with this comprehensive programming reference. Database
developers and administrators get best practices, expert
techniques, and code samples to master the intricacies of
this programming language-solving complex problems with
real-world solutions. Discover how to: Work with T-SQL
and CLR user-defined functions, stored procedures, and
triggers. Handle transactions, concurrency, and error
handling. Efficiently use temporary objects, including
temporary tables, table variables, and table
expressions. Evaluate when to use set-based programming
techniques and when to use cursors. Work with dynamic
SQL in an efficient and secure manner. Treat date- and
time-related data in a robust manner. Develop CLR user-
defined types and learn about temporal support in the
relational model. Use XML and XQuery and implement a
dynamic schema solution. All the book's code samples will
be available for download from the companion Web site.
|
| |
| ISBN: |
0735626022 |
| ISBN-13: |
9780735626027 |
| Author: |
Ben-Gan, Itzik et al |
| Published: |
15/10/2009 |
| Availability: |
Order will be despatched within 24 hours |
| Price: |
$ 79.95 Inc GST |
| |
|
|
| © 2010 Microsoft Press Shop |
|
|
|
|
|
Teach yourself to use SQL Server 2008 Analysis Services
for business intelligence-one step at a time. You'll
start by building your understanding of the business
intelligence platform enabled by SQL Server and the
Microsoft Office System, highlighting the role of
Analysis Services. Then, you'll create a simple
multidimensional OLAP cube and progressively add features
to help improve, secure, deploy, and maintain an Analysis
Services database. You'll explore core Analysis Services
2008 features and capabilities, including dimension,
cube, and aggregation design wizards; a new attribute
relationship designer; designer AMO warnings; and using
dynamic management views to monitor resources. And as you
complete each lesson, you can hone your skills using the
practice exercises from the companion CD. Plus, you can
review and download code samples illustrating the
author's own, professional techniques-direct from the
companion Web site.
|
| |
| ISBN: |
0735626200 |
| ISBN-13: |
9780735626201 |
| Author: |
Cameron, Scott |
| Published: |
04/05/2009 |
| Availability: |
Order will be despatched within 24 hours |
| Price: |
$ 79.95 Inc GST |
| |
|
|
| © 2010 Microsoft Press Shop |
|
|
|
|
|
Delve into the internal architecture of T-SQL-and unveil
the power of set-based querying-with comprehensive
reference and advice from a highly regarded T-SQL expert
and members of Microsoft's SQL Server development team.
Database developers and administrators will examine the
best practices, advanced techniques, sample databases,
and code needed to master the programming language built
into SQL Server-solving complex problems with real-world
solutions. All the book's code samples will be available
for download from the companion Web site.
|
| |
| ISBN: |
0735626030 |
| ISBN-13: |
9780735626034 |
| Author: |
Ben-gan, I, |
| Published: |
25/04/2009 |
| Availability: |
Order will be despatched within 24 hours |
| Price: |
$ 79.95 Inc GST |
| |
|
|
| © 2010 Microsoft Press Shop |
|
|
|
|
|
Explore the definitive guide to the internals and
architecture of the Microsoft SQL Server 2008 relational
database engine. The author-an expert on SQL Server
internals-offers the guidance developers and database
administrators need to understand how SQL Server internal
structures affect application development and
functionality. Get the practical guidance needed to
understand and maximize the SQL Server architecture,
including information about logging and recovery,
indexes, tables, transactions and locking, and security.
This complete reference offers numerous code samples,
table examples, and practical advice.
|
| |
| ISBN: |
0735626243 |
| ISBN-13: |
9780735626249 |
| Author: |
Delaney, Kalen et al |
| Published: |
26/03/2009 |
| Availability: |
Order will be despatched within 24 hours |
| Price: |
$ 97.95 Inc GST |
| |
|
|
| © 2010 Microsoft Press Shop |
|
|
|
|
|
|
|
|
|