Introducing Microsoft SQL Server 2016
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 > Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)


     0     
5
4
3
2
1



Out of Stock


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

With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this Preview 2 ebook, we introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancement, and R integration. This book is a preview edition because it’s not complete; the final edition will be available Spring of 2016.

Table of Contents:
Chapter 2: Better security     1 Always Encrypted     1 Getting started with Always Encrypted     1 Creating a table with encrypted values     7 CREATE TABLE statement for encrypted columns     7 Migrating existing tables to Always Encrypted     9 Row-Level Security     11 Creating inline table functions     11 Creating security policies     14 Using block predicates     15 Dynamic data masking     15 Dynamic data masking of a new table     16 Dynamic data masking of an existing table     16 Understanding dynamic data masking and permissions     17 Masking encrypted values     18 Using dynamic data masking in SQL Database     18 Chapter 3: Higher availability     20 AlwaysOn Availability Groups     20 Supporting disaster recovery with basic availability groups     21 Using group Managed Service Accounts     23 Triggering failover at the database level     23 Supporting distributed transactions     24 Scaling out read workloads     25 Defining automatic failover targets     26 Reviewing the improved log transport performance     27 Windows Server 2016 Technical Preview high-availability enhancements     28 Creating workgroup clusters     29 Configuring a cloud witness     30 Using Storage Spaces Direct     32 Introducing site-aware failover clusters     33 Windows Server Failover Cluster logging     33 Performing rolling cluster operating system upgrades     33 Chapter 4: Improved database engine     35 TempDB enhancements     35 Configuring data files for TempDB     36 Eliminating specific trace flags     37 Query Store     38 Enabling Query Store     38 Understanding Query Store components     39 Reviewing information in the query store     40 Using Force Plan     42 Managing the query store     43 Tuning with the query store     44 Stretch Database     44 Understanding Stretch Database architecture     45 Security and Stretch Database     45 Identifying tables for Stretch Database     46 Configuring Stretch Database     47 Monitoring Stretch Database     48 Backup and recovery with Stretch Database     49 Chapter 6: More analytics     50 Tabular enhancements     50 Accessing more data sources with DirectQuery     51 Modeling with a DirectQuery source     51 Working with calculated tables     54 Bidirectional cross-filtering     56 Writing formulas     60 Introducing new DAX functions     60 Using variables in DAX     63 R integration     64 Installing and configuring R Services     64 Getting started with R Services     65 Using an R Model in SQL Server     74 Chapter 7: Better reporting     77 Report content types     77 Paginated report development enhancements     77 Introducing changes to paginated report authoring tools     78 Exploring new data visualizations     79 Managing parameter layout in paginated reports     84 Mobile report development     85 KPI development     85 Report access enhancements     86 Accessing reports with modern browsers     86 Viewing reports on mobile devices     88 Printing without ActiveX     88 Exporting to PowerPoint     90 Pinning reports to Power BI     92 Managing subscriptions     93 About the authors     96

About the Author :
Stacia Varga is a consultant, educator, mentor, and author specializing in business intelligence and performance management solutions using Microsoft technologies. She has over 25 years of experience with improving business practices through technology. Her exclusive focus has been on business intelligence since 1999. Also, she is a co-author of various editions of the free ebook "Introducing Microsoft SQL Server," published by Microsoft Press.  Denny Cherry is an expert in the design and administration of Microsoft SQL Server (6.5-2014) database solutions at both the hardware and software levels of the design process. On the software side he has expert-level knowledge of a wide variety of Microsoft software, including Microsoft SQL Server (6.5-2014), Microsoft SQL Server Analysis Server (7-2014), Microsoft SQL Server Integration Services (2005-2014), Microsoft SQL Server Replication (7-2014), Microsoft Windows Server (NT4 - 2012 R2), Microsoft Cluster Services (2000-2012 R2), and Microsoft Load Balancing Services (2000-2012 R2). Joseph D'Antoni is a Senior Consultant and SQL Server MVP with over a decade of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry and Associates and lives in Malvern, PA. He is a frequent speaker at major tech events, and blogger about all topics technology. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft white paper "Using Power BI in a Hybrid Environment.”


Best Sellers


Product Details
  • ISBN-13: 9781509301942
  • Publisher: Microsoft Press,U.S.
  • Publisher Imprint: Microsoft Press
  • Language: English
  • Series Title: Introducing
  • Weight: 1 gr
  • ISBN-10: 1509301941
  • Publisher Date: 23 Nov 2015
  • Binding: Digital download
  • No of Pages: 65
  • Sub Title: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)
Microsoft Press,U.S. -
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)
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.

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2(Introducing)

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!