Microsoft� SQL Server� 2012

ISBN-10: 0735663769

ISBN-13: 9780735663763

Edition: 2012

List price: $41.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server Code Name “Denali”. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!Get fast facts to:Manage SQL Server services and clientsConfigure, manage, and tune serversImplement policy-based managementAdminister security and accessImport, export, transform, and replicate dataManage log shipping and database mirroringMonitor server activity and tune performanceAutomate maintenancePerform backups and recovery

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $41.99
Copyright year: 2012
Publisher: Pearson Education Canada
Publication date: 2/15/2012
Binding: Paperback
Pages: 592
Size: 5.50" wide x 8.50" long x 1.50" tall
Weight: 1.430
Language: English

William R. Stanek has over 20 years of hands-on experience with advanced programming and development. He has written 61 books including: "Microsoft Windows Server 2003 Administrator's Pocket Consultant", "Windows Server 2003 Inside Out", "Microsoft Exchange Server 2003 Administrator's Pocket Consultant", and "Microsoft IIS 6.0 Administrator's Pocket Consultant" (all from Microsoft Press). These are currently the best sellers in their respective markets. Mr. Stanek has an MS degree in Information Systems with distinction, and a BS degree in Computer Science magna cum laude.

Introduction
Who Is This Book For?
How Is This Book Organized?
What Is SQL Server 2012?
System Requirements
Conventions Used in This Book
Other Resources
Support and Feedback
Microsoft SQL Server 2012 Essentials
Managing Your SQL Servers
Using SQL Server Management Studio
Managing SQL Server Groups
Managing Servers
Using Windows PowerShell for SQL Server Management
Starting, Stopping, and Configuring SQL Server Agent
Starting, Stopping, and Configuring MSDTC
Managing SQL Server Startup
Managing Server Activity
Managing SQL Server Services and Clients
Managing SQL Server Component Feature Access
Managing the Network and SQL Server Native Client Configuration
Understanding the Services Configuration
Configuring SQL Server Services; Microsoft SQL Server 2012 Management and Security
Implementing Policy-Based Management
Introducing Policy-Based Management
Working with Policy-Based Management
Configuring Central Management Servers
Managing Policies Throughout the Enterprise
Configuring and Tuning Your SQL Servers
Accessing SQL Server Configuration Data
Techniques for Managing SQL Server Configuration Options
Configuring SQL Server with Stored Procedures
Tuning and Linking Your SQL Servers
SQL Server Management Studio Essentials
Working with Linked Servers and Distributed Data
Configuring Authentication and Auditing
Tuning Memory Usage
Configuring Processors and Parallel Processing
Configuring Threading, Priority, and Fibers
Configuring User and Remote Connections
Managing Server Settings
Managing Database Settings
Managing Linked Servers
Troubleshooting Configuration Problems
Database Administration Essentials
Database Files and Logs
Database Administration Basics
Creating Databases
Altering Databases and Their Options
Managing Database and Log Size
Manipulating Databases
Tips and Techniques
Implementing SQL Server 2012 Security
Overview of SQL Server 2012 Security
SQL Server 2012 Authentication Modes
Special-Purpose Logins and Users
Permissions
Roles
Managing Server Logins
Configuring Server Roles
Controlling Database Access and Administration
Managing Database Permissions; Microsoft SQL Server 2012 Data Management
Manipulating Schemas, Tables, and Views
Working with Schemas
Getting Started with Tables
Table Essentials
Working with Tables
Managing Table Values
Using Views
Using Indexes, Constraints, and Partitions
Creating and Managing Indexes
Working with Columnstore Indexes
Column Constraints and Rules
Creating Partitioned Tables and Indexes
Compressing Tables, Indexes, and Partitions; Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery
Automating and Maintaining SQL Server 2012
Database Automation and Maintenance
Using Database Mail
Using SQL Server Agent
Managing Alerts
Managing Operators
Scheduling Jobs
Automating Routine Server-to-Server Administration Tasks
Multiserver Administration
Database Maintenance
SQL Server 2012 Backup and Recovery
Creating a Backup and Recovery Plan
Selecting Backup Devices and Media
Using Backup Strategies
Creating a Backup Device
Performing Backups
Restoring a Database
Restoring the master Database
SQL Server 2012 Profiling and Monitoring
Monitoring Server Performance and Activity
Working with Replication Monitor
Working with the Event Logs
Monitoring SQL Server Performance
Configuring a Management Data Warehouse
Solving Performance Problems with Profiler
About the Author
About the Technical Reviewer
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×