Microsoft SQL Server 2012 Management and Administration: Edition 2

Sams Publishing
3
Free sample

If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a worldclass expert on running SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s first cloud-enabled database platform. Designed for maximum practical usability, it’s packed with expert tips and up-to-date real-world configuration guidance you simply won’t find anywhere else.

As someone who helped influence the design of SQL Server 2012 and drawing on many months of beta testing, Ross Mistry provides immediately usable solutions for installation and upgrades, management and monitoring, performance and availability, security, consolidation, virtualization, troubleshooting, and more. Mistry identifies new features and corresponding best practices in every chapter, helping you take full advantage of new SQL Server innovations ranging from private cloud support to AlwaysOn Availability Groups.

Understand how to:
  • Efficiently install or upgrade the SQL Server 2012 database engine
  • Administer and configure database engine settings, storage, I/O, and partitioning
  • Transfer data on-premise or to the cloud
  • Manage and optimize indexes
  • Learn how to consolidate, virtualize and optimize SQL Server for Private Clouds
  • Harden and audit SQL Server 2012 environments
  • Administer security and authorization, including new Contained Databases
  • Encrypt data and communications
  • Design and deploy new AlwaysOn high-availability and disaster recovery features
  • Implement maintenance best practices, including Policy-Based Management

Read more
Collapse

About the author

Ross Mistry is an author, public speaker, principal enterprise architect, and veteran in the Silicon Valley. He has published numerous books and articles and frequently speaks at conferences worldwide.

With more than 15 years of experience, Ross has been a trusted advisor providing strategic guidance for many C-level executives and has been responsible for planning and implementing technology solutions for some of the largest companies in the world. He has taken on the lead architect role for many Silicon Valley internet startups and Fortune 100 organizations, including Network Appliance, McAfee, The Sharper Image, Visa, CIBC, Levi’s, Wells Fargo, and Intel. He specializes in data platform, business productivity, unified communications, core infrastructure, and private cloud.

At Microsoft, Ross is a director and principal enterprise architect at the Microsoft Technology Centers (MTCs). The MTCs are collaborative environments that provide access to innovative technologies and world-class expertise, giving organizations the ability to envision, design, and deploy solutions to meet their exact needs. He is currently in the process of launching and leading the first MTC in Canada.

Ross is an active participant in the SQL Server community. He comanaged the main Microsoft SQL Server Twitter account @SQLServer and frequently speaks at technology conferences around the world. He has recently spoken at TechEd, PASS Summit, SQL Connections, and SQL BITS. He is a series author and has formulated many best practices and written many whitepapers and articles for Microsoft, SQL Server Magazine, and Techtarget.com.

Read more
Collapse
4.7
3 total
Loading...

Additional Information

Publisher
Sams Publishing
Read more
Collapse
Published on
Sep 6, 2012
Read more
Collapse
Pages
984
Read more
Collapse
ISBN
9780132977654
Read more
Collapse
Read more
Collapse
Read more
Collapse
Language
English
Read more
Collapse
Genres
Computers / Databases / General
Read more
Collapse
Content Protection
This content is DRM protected.
Read more
Collapse
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014.


You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the
most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions.


Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server.


Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features.


Detailed information on how to…

Understand SQL Server 2014’s new features and each edition’s capabilities and licensing Install, upgrade to, and configure SQL Server 2014 for better performance and easier management Streamline and automate key administration tasks with Smart Admin Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups Strengthen security with new features for enforcing “least privilege” Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures Control workloads and Disk I/O with the Resource Governor Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured


Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.


Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.


You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.


With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...

Use the major SQL statements Construct complex SQL statements using multiple clauses and operators Retrieve, sort, and format database contents Pinpoint the data you need using a variety of filtering techniques Use aggregate functions to summarize data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, and more Table of Contents

1 Understanding SQL

2 Retrieving Data

3 Sorting Retrieved Data

4 Filtering Data

5 Advanced Data Filtering

6 Using Wildcard Filtering

7 Creating Calculated Fields

8 Using Data Manipulation Functions

9 Summarizing Data

10 Grouping Data

11 Working with Subqueries

12 Joining Tables

13 Creating Advanced Joins

14 Combining Queries

15 Inserting Data

16 Updating and Deleting Data

17 Creating and Manipulating Tables

18 Using Views

19 Working with Stored Procedures

20 Managing Transaction Processing

21 Using Cursors

22 Understanding Advanced SQL Features

Appendix A: Sample Table Scripts

Appendix B: Working in Popular Applications

Appendix C : SQL Statement Syntax

Appendix D: Using SQL Datatypes

Appendix E: SQL Reserved Words


If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

Understand how to: Master DBA tips, tricks, and best practices proven in actual enterprise environments Install, upgrade or transition to SQL Server 2008. Harden and Secure an implementation. Encrypt SQL Server from an end-to-end perspective. Implement high availability—and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring Save time with SQL Server 2008’s new policy-based management tools Performance tune and troubleshoot a SQL Server 2008 environment. Optimize application performance and manage workloads with the powerful new Resource Governor Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more… Bonus Content: The book is based on Windows Server 2008 Step by step instructions of how to implement a failover cluster on Windows Server 2008 SQL Server PoweShell Administration Tasks Consolidate and virtualize SQL Server with Hyper-V Step by step instructions on how to install Hyper-V Proactively Monitor SQL Server with Operations Manager Install Windows Server 2008 certificates to encrypt SQL Server data Contributing Writers include:

Hilary Cotter – SQL Server MVP

John Welch – SQL Server MVP

Marco Shaw – PowerShell MVP

Maciej Pilecki – SQL Server MVP

Shirmattie Seenarine – Technical Writer

Perfect for end users, analysts,  data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples.


- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.

- Learn the core language for standard SQL, and variations for the most widely used database systems.

- Organize your database in terms of the relational model.

- Master tables, columns, rows, and keys.

- Retrieve, sort, and format data.- Filter the data that you don't want to see.

- Convert and manipulate data with SQL's built-in functions and operators.

- Use aggregate functions to summarize data.

- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.

- Create, alter, and drop tables, indexes, and views.

- Insert, update, delete, and merge data.

- Execute transactions to maintain the integrity of your data.

- Avoid common pitfalls involving nulls.

- Troubleshoot and optimize queries.

- Plenty of tips, tricks, and timesavers.

- Fully cross-referenced, linked, and searchable.


Contents

Introduction

1. Running SQL Programs

2. The Relational Model

3. SQL Basics

4. Retrieving Data from a Table

5. Operators and Functions

6. Summarizing and Grouping Data

7. Joins

8. Subqueries

9. Set Operations

10. Inserting, Updating, and Deleting Rows

11. Creating, Altering, and Dropping Tables

12. Indexes

13. Views

14. Transactions


Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these objectives:

• Filter, sort, join, aggregate, and modify data

• Use subqueries, table expressions, grouping sets, and pivoting

• Query temporal and non-relational data, and output XML or JSON

• Create views, user-defined functions, and stored procedures

• Implement error handling, transactions, data types, and nulls

This Microsoft Exam Ref:

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer

• Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database

Querying Data with Transact-SQL

About the Exam

Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases

with Transact-SQL in SQL Server 2016.

About Microsoft Certification

Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification.

See full details at: microsoft.com/learning

©2019 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.