Tournament of Books 2015
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | January 14, 2015

    Marie Mutsuki Mockett: IMG On Trimming Roses



    Gardens do not wait. Weeds grow and flowers wilt. In the days and weeks following my father's death, my parents' garden continued to flourish and... Continue »

    spacer

Microsoft SQL Server 2012 Unleashed with Access Code (Unleashed)

Microsoft SQL Server 2012 Unleashed with Access Code (Unleashed) Cover

 

Synopses & Reviews

Publisher Comments:

Buy the print version of¿ Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details.

¿

With up-to-the-minute content, this is the industry’s most complete, useful guide to SQL Server 2012.

¿

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 samples you’ll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more.

¿

Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product’s most complex and powerful capabilities, and its newest tools and features.

  • Understand SQL Server 2012’s newest features, licensing changes, and capabilities of each edition
  • Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell
  • Use Policy-Based Management to centrally configure and operate SQL Server
  • Utilize the new Extended Events trace capabilities within SSMS
  • Maximize performance by optimizing design, queries, analysis, and workload management
  • Implement new best practices for SQL Server high availability
  • Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery
  • Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse
  • Deliver better full-text search with SQL Server 2012’s new Semantic Search
  • Improve reporting with new SQL Server 2012 Reporting Services features

Download the following from informit.com/title/9780672336928: Sample databases and code examples

¿

¿

Synopsis:

Buy the print Microsoft SQL Server 2012 Unleashed and get the eBook version for free! See inside the book for access code and details.

With 30-40% new and updated coverage, this is the industry’s most complete and useful guide to SQL Server 2012. You’ll find everything here: start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to integration, reporting, analysis, development, optimization, security, and much more.

¿

Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions with the latest versions of SQL Server. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find 4 new chapters covering:

  • SQL Server 2012’s new Always-On feature
  • SQL Azure cloud solutions
  • Master Data Services (MDS) and Data Quality Services (DQS)
  • The Parallel Data Warehouse Appliance

SQL Server 2012 Unleashed contains updated SQL code examples, sample databases, and application code to help you take full advantage of these and other new features and capabilities. This comprehensive guide has also been reorganized for easier access, with complete sections on both high availability and security. No other guide offers as much expert guidance on efficiently implementing administering, securing, optimizing, supporting, and troubleshooting SQL Server 2012, and making it work effectively for your organization.

About the Author

Ray Rankins is owner and president of Gotham Consulting Services, Inc. (http://www.gothamconsulting.com), near Saratoga Springs, New York. Ray has been working with Sybase and Microsoft SQL Server for more than 24 years and has experience in database administration, database design, project management, application development, consulting, courseware development, and training. He has worked in a variety of industries, including financial, manufacturing, health care, retail, insurance, communications, public utilities, and state and federal government. His expertise is in database performance and tuning, query analysis, advanced SQL programming and stored procedure development, database design, data architecture, and database application design and development. Ray’s presentations on these topics at user group conferences have been very well received. Ray is coauthor of Microsoft SQL Server 2008 R2 Unleashed, Microsoft SQL Server 2005 Unleashed , Microsoft SQL Server 2000 Unleashed , Microsoft SQL Server 6.5 Unleashed , Sybase SQL Server 11 Unleashed , and Sybase SQL Server 11 DBA Survival Guide, all published by Sams Publishing. As an instructor, Ray brings his real-world experience into the classroom, teaching courses on SQL, advanced SQL programming and optimization, database design, database administration, and database performance and tuning. Ray can be reached at rrankins@gothamconsulting.com.

 

Paul Bertucci is the founder of Data by Design, LLC (www.dataxdesign.com–formerly Database Architechs), a global database consulting firm with offices in the United States and Paris, France. He is also the Chief Architect and runs a global Shared Services team for Autodesk, Inc. (teams: BI/DW/ODS, Big Data, Identity Management, SOA, Integration (EAI & ETL), MDM, Collaboration/Social, SaaS application platforms, and Enterprise Architecture). He was also the former Chief Data Architect at Symantec for many years. Paul has more than 30 years of experience with database design, data architecture, big data, data replication, performance and tuning, master data management (MDM), data provenance/DataDNA, distributed data systems, data integration, high-availability, enterprise architect, identity management, SOA, SaaS, and systems integration for numerous Fortune 500 companies, including Intel, Coca-Cola, Apple, Toshiba, Lockheed, Wells Fargo, Safeway, Sony, Charles Schwab, Cisco Systems, Sybase, Symantec, Veritas, and Honda, to name a few. He has authored numerous database articles, data standards, and high-profile database courses, such as Sybase’s “Performance and Tuning” and “Physical Database Design” courses. Other Sams Publishing books that he has authored include the highly popular Microsoft SQL Server 2000 Unleashed, ADO.NET in 24 Hours, Microsoft SQL Server High Availability, Microsoft SQL Server 2005 Unleashed, and Microsoft SQL Server 2008 R2 Unleashed. Mr. Bertucci is a frequent speaker at industry conferences such as Informatica World, Oracle World, MDM Summits, and Microsoft-oriented conferences such as SQL Saturday’s, Silicon Valley Code-Camp, PASS conferences, Tech Ed’s, and SQL Server User Groups. He has deployed numerous systems with Microsoft SQL Server, Sybase, DB2, Postgres, MySQL, NoSQL, Paraccel, Hadoop and Oracle database engines, and he has designed/architected several commercially available tools in the database, data modeling, performance and tuning, data integration, digital DNA, and multidimensional planning spaces. Paul received his formal education in computer science and electrical engineering from UC Berkeley (Go Bears!). He lives in the great Pacific Northwest (Oregon) with his five children, Donny, Juliana, Nina, Marissa, and Paul Jr. Paul can be reached at pbertucci@dataxdesign.com or Bertucci@Alum.CalBerkeley.Org.

 

Chris Gallelli is the president of CGAL Consulting Services, Inc. His company focuses on consulting services in the areas of database administration, database tuning, advanced stored procedure development, Integration Services, Powershell development and database programming using Microsoft Visual Studio. He has provided SQL Server based solutions for a variety of customers including several Fortune 500 companies. Chris has more than 20 years of experience with SQL Server or Sybase and more than 25 years in the field of information technology. He has a bachelor’s degree in electrical engineering and a master’s degree in business administration from Union College. Chris currently lives near Albany, New York, with his lovely wife, Laura, and two beautiful daughters, Rachael and Kayla. Other Sams Publishing books that he has coauthored include Microsoft SQL Server 2000 Unleashed, Microsoft SQL Server 2005 Unleashed, and Microsoft SQL Server 2008 R2 Unleashed. Chris can be reached at cgallelli@gmail.com.

 

Alex T. Silverstein is owner and chief information officer of Unified Digital Group, LLC (http://unifieddigital.com), a custom database administration and software development firm headquartered near Saratoga Springs, New York. He specializes in designing high availability software systems using the principles of agile development. Alex has more than 15 years of experience providing application development, database administration, and training services worldwide to a variety of industries. He was also a coauthor for Microsoft SQL Server 2005 Unleashed and Microsoft SQL Server 2008 R2 Unleashed and a contributing author for Microsoft SQL Server 2000 Unleashed, all published by Sams Publishing. You can reach Alex anytime via email at alex@unifieddigital.com.

 

Hilary Cotter is a SQL Server MVP with more than 20 years of IT experience working for Fortune 500 clients. He is the author of a book on SQL Server Replication and coauthor of Microsoft SQL Server 2008 Management and Administration from Sams Publishing. Hilary has also written numerous white papers and articles on SQL Server and databases.

 

Table of Contents

Note: To be updated; reflects SQL Server 2008 R2 Unleashed.  The new edition's updates include four new chapters not reflected in the TOC below; these new chapters will cover Always-On; SQL Azure; Master Data Services/Data Quality Services, and the Parallel Data Warehouse Appliance.

 

Part I: Welcome to Microsoft SQL Server

1. SQL Server 2008 Overview

2. What's New in SQL Server 2008

3. Examples of SQL Server Implementations

Part II: SQL Server Tools and Utilities

4. SQL Server Management Studio

5. SQL Server Command-Line Utilities

6. SQL Server Profiler

Part III: SQL Server Administration

7. SQL Server System and Database Administration

8. Installing SQL Server 2008

9. Upgrading to SQL Server 2008

10. Client Installation and Configuration

11. Security and User Administration

12. Data Security

13. Security and Compliance

14. Database Backup and Restore

15. Database Mail

16. SQL Server Scheduling and Notification

17. Automating SQL Server Tasks using PowerShell

18. SQL Server High Availability

19. Replication

20. Database Mirroring

21. SQL Server Clustering

Part IV: Database Administration

22. Creating and Managing Databases

23. Creating and Managing Tables

24. Creating and Managing Indexes

25. Implementing Data Integrity

26. Creating and Managing Views in SQL Server

27. Creating and Managing Stored Procedures

28. Creating and Managing User-Defined Functions

29. Creating and Managing Triggers

30. Transaction Management and the Transaction Log

31. Database Snapshots

32. Database Maintenance

Part V: SQL Server Performance and Optimization

33. Data Structures,Indexes and Performance

34. Understanding Query Optimization

35. Query Analysis

36. Locking and Performance

37. Database Design and Performance

38. Monitoring SQL Server Performance

39. A Performance and Tuning Methodology

40. What's New for Transact-SQL in SQL Server 2008

41. Creating .Net CLR Objects in SQL Server 2008

42. Using XML in SQL Server 2008

Part VII: SQL Server Business Intelligence Features

43. SQL Server 2008 Analysis Services

44. SQL Server Integration Services

45. SQL Server 2008 Reporting Services

Part VIII: Bonus Chapters on the CD

46. Managing Linked and Remote Servers

47. Configuring, Tuning, and Optimizing SQL Server Options

48. Administering Very Large SQL Server Databases

49. SQL Server Disaster Recovery Planning

50. Transact-SQL Programming Guidelines, Tips, and Tricks

51. SQL Server and the .NET Framework

52. SQL Server Web Services

53. SQL Server Service Broker

54. SQL Server Full-Text Search

Product Details

ISBN:
9780672336928
Publisher:
Sams
Subject:
Database design
Author:
Bertucci, Paul T.
Author:
Silverstein, Alex T.
Author:
Rankins, Ray
Author:
Bertucci, Paul
Author:
Gallelli, Chris
Subject:
Database Management - General
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL
Subject:
Server high availability; SQL Server best practices; SQL Server optimization; SQL Server reporting; SQL Server analysis; SQL Server development; advanced SQL Server
Subject:
SQL Server 2012; SQL Server consultants; SQL Server code; T-SQL; SQL Server DBA; Always-On; SQL Azure; Master Data Services; Data Quality Services, MDS: DQS; Parallel Data Warehouse Appliance; SQL Server high availability; SQL Server best practices; SQL S
Copyright:
Edition Description:
Trade paper
Series:
Unleashed
Publication Date:
20130927
Binding:
TRADE PAPER
Language:
English
Pages:
1872
Dimensions:
9.1 x 7 x 2.4 in 2477 gr

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Metaphysics » General

Microsoft SQL Server 2012 Unleashed with Access Code (Unleashed)
0 stars - 0 reviews
$ In Stock
Product details 1872 pages Sams - English 9780672336928 Reviews:
"Synopsis" by ,

Buy the print Microsoft SQL Server 2012 Unleashed and get the eBook version for free! See inside the book for access code and details.

With 30-40% new and updated coverage, this is the industry’s most complete and useful guide to SQL Server 2012. You’ll find everything here: start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to integration, reporting, analysis, development, optimization, security, and much more.

¿

Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions with the latest versions of SQL Server. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find 4 new chapters covering:

  • SQL Server 2012’s new Always-On feature
  • SQL Azure cloud solutions
  • Master Data Services (MDS) and Data Quality Services (DQS)
  • The Parallel Data Warehouse Appliance

SQL Server 2012 Unleashed contains updated SQL code examples, sample databases, and application code to help you take full advantage of these and other new features and capabilities. This comprehensive guide has also been reorganized for easier access, with complete sections on both high availability and security. No other guide offers as much expert guidance on efficiently implementing administering, securing, optimizing, supporting, and troubleshooting SQL Server 2012, and making it work effectively for your organization.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.