Buy Microsoft SQL Server 2012 Bible Book by Aaron Nelson
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Microsoft SQL Server 2012 Bible: (773 Bible)
Microsoft SQL Server 2012 Bible: (773 Bible)

Microsoft SQL Server 2012 Bible: (773 Bible)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services Demonstrates tasks both graphically and in SQL code to enhance your learning Provides source code from the companion web site, which you can use as a basis for your own projects Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

Table of Contents:
Introduction    xxix Part I: Laying the Foundations 1 Chapter 1: The World of SQL Server    3 Chapter 2: Data Architecture     15 Chapter 3: Installing SQL Server     31 Chapter 4: Client Connectivity       71 Chapter 5: SQL Server Management and Development Tools     81 Part II: Building Databases and Working with Data 109 Chapter 6: Introducing Basic Query Flow    111 Chapter 7: Relational Database Design and Creating the Physical Database Schema      143 Chapter 8: Data Types, Expressions, and Scalar Functions      173 Chapter 9: Merging Data with Joins, Subqueries, and CTEs     213 Chapter 10: Aggregating, Windowing, and Ranking Data    249 Chapter 11: Projecting Data Through Views     271 Chapter 12: Modifying Data In SQL Server      291 Part III: Advanced T-SQL Data Types and Querying Techniques 323 Chapter 13: Working with Hierarchies      325 Chapter 14: Using XML Data       339 Chapter 15: Executing Distributed Queries      367 Part IV: Programming with T-SQL 387 Chapter 16: Programming with T-SQL       389 Chapter 17: Developing Stored Procedures     431 Chapter 18: Building User-Defi ned Functions    453 Part V: Enterprise Data Management 467 Chapter 19: Confi guring SQL Server     469 Chapter 20: Policy Based Management     531 Chapter 21: Backup and Recovery Planning     547 Chapter 22: Maintaining the Database     585 Chapter 23: Transferring Databases     615 Chapter 24: Database Snapshots      635 Chapter 25: Asynchronous Messaging with Service Broker      647 Chapter 26: Log Shipping      661 Chapter 27: Database Mirroring     685 Chapter 28: Replicating Data       727 Chapter 29: Clustering      745 Chapter 30: Confi guring and Managing SQL Server with PowerShell  769 Chapter 31: Managing Data in Windows Azure SQL Database   801 Part VI: Securing Your SQL Server 831 Chapter 32: Authentication Types in SQL Server     833 Chapter 33: Authorizing Securables     841 Chapter 34: Data Encryption       853 Chapter 35: Row-Level Security     861 Part VII: Monitoring and Auditing 877 Chapter 36: Creating Triggers      879 Chapter 37: Performance Monitor and PAL     909 Chapter 38: Using Profi ler and SQL Trace    919 Chapter 39: Wait States    931 Chapter 40: Extended Events       937 Chapter 41: Data Change Tracking and Capture     945 Chapter 42: SQL Audit      967 Chapter 43: Management Data Warehouse     977 Part VIII: Performance Tuning and Optimization 993 Chapter 44: Interpreting Query Execution Plans     995 Chapter 45: Indexing Strategies   1005 Chapter 46: Maximizing Query Plan Reuse     1041 Chapter 47: Managing Transactions, Locking, and Blocking    1047 Chapter 48: Data Compression    1097 Chapter 49: Partitioning      1109 Chapter 50: Resource Governor    1131 Part IX: Business Intelligence 1141 Chapter 51: Business Intelligence Database Design    1143 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services      1155 Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX   1195 Chapter 54: Confi guring and Administering Analysis Services     1223 Chapter 55: Authoring Reports in Reporting Services   1233 Chapter 56: Configuring and Administering Reporting Services    1261 Chapter 57: Data Mining with Analysis Services    1281 Chapter 58: Creating and Deploying BI Semantic Models      1299 Chapter 59: Creating and Deploying Power View Reports      1327 Index      1347

About the Author :
Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), a SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential using their data in ways they have not previously imagined. Adam is very involved in the community, delivering more than 75 community sessions per year. Based in Jacksonville, FL, Adam has written and contributed to five previous books on SQL Server, analytics, and SharePoint. Coauthors Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are well-known experts on SQL Server and Business Intelligence.


Best Sellers


Product Details
  • ISBN-13: 9781118283868
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: John Wiley & Sons Inc
  • Language: English
  • Series Title: 773 Bible
  • ISBN-10: 1118283864
  • Publisher Date: 06 Aug 2012
  • Binding: Digital (delivered electronically)
  • No of Pages: 1416


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server 2012 Bible: (773 Bible)
John Wiley & Sons Inc -
Microsoft SQL Server 2012 Bible: (773 Bible)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft SQL Server 2012 Bible: (773 Bible)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!