MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server 2014 Administration New Features

Course Summary

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancement


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Evolution of SQL Server
        ◦ What Is This Course About?
        ◦ What Is in This Course?
        ◦ Summary
    ● Backup Enhancement
        ◦ Introduction
        ◦ Prerequisite Software
        ◦ Backup Encryption
        ◦ Understanding Prerequisites
        ◦ Demo: Prerequisites
        ◦ Demo: Backup Encryption
        ◦ Demo: Restoring Encrypted Backup
        ◦ Demo: Backup Encryption - Advanced
        ◦ Summary
    ● Security Enhancements
        ◦ Introduction
        ◦ Scenario - Visiting Auditor
        ◦ Demo: Enhancement of User Object Permissions
        ◦ Scenario - Case of Impersonation
        ◦ Demo: Traditional Impersonation
        ◦ Demo: Impersonation of System Admin
        ◦ Demo: Enhancement of Impersonation Permission
        ◦ Summary
    ● Columnstore Index Enhancements
        ◦ Introduction
        ◦ Columnstore Index Enhancements
        ◦ Generic Columnstore Characteristics
        ◦ Columnstore Characteristics - SQL Server 2012
        ◦ Columnstore Characteristics - SQL Server 2014
        ◦ Demo: Nonclustered Columnstore Index
        ◦ Demo: Clustered Columnstore Index
        ◦ Demo: Clustered Columnstore Index Advanced
        ◦ Demo: Columnstore Index and Performance
        ◦ Demo: Columnstore Index and Storage
        ◦ Columnstore Internals
        ◦ Columnstore Architecture
        ◦ Demo: Columnstore Internals
        ◦ Summary
    ● Online Database Operational Enhancements
        ◦ Introduction
        ◦ Real World Remarks
        ◦ Online Operations With SQL Server 2012
        ◦ Changes With SQL Server 2014 With Online Operations
        ◦ Managed Lock Priority Options
        ◦ Demo: SQL Server 2012 Online Index Operation
        ◦ Demo: SQL Server 2014 Online Index Operation
        ◦ Demo: Managed Lock Priority Options
        ◦ Demo: SQL Server 2014 Online Partition Operation
        ◦ Summary
    ● Enhancements With Microsoft Azure
        ◦ Introduction
        ◦ Backup Scenario Today
        ◦ Backup Scenario on Cloud
        ◦ Encrypted Backup and Restore Scenario to Cloud
        ◦ Advantages of Backup With Azure
        ◦ Backup to URL
        ◦ Prerequisite
        ◦ Demo: Prerequisite Setup
        ◦ Demo: Manual Backup to Azure
        ◦ Demo: Manual Backup to Azure With Encryption
        ◦ Demo: Manual Restore From Azure With Encryption
        ◦ What Is Automated Managed Backup?
        ◦ Sequence for Automated Managed Backup
        ◦ Demo: Automated Managed Backup
        ◦ Demo: Managed Backup at Database Level
        ◦ Demo: Managed Backup at Instance Level
        ◦ SQL Server Data Files in Windows Azure
        ◦ Demo: SQL Server Data Files in Windows Azure
        ◦ Summary
    ● Buffer Pool Extension
        ◦ Introduction
        ◦ Why Buffer Pool Extension?
        ◦ Benefits of Buffer Pool Extension
        ◦ How Buffer Pool Extension Works
        ◦ Buffer Movement and Eviction
        ◦ Demo: Buffer Pool Extension
        ◦ Summary
    ● Resource Governor IO Enhancements
        ◦ Introduction
        ◦ Why Resource Governor?
        ◦ Resource Governor IO Control
        ◦ Syntax
        ◦ Demo: Resource Governor Setup
        ◦ Demo: Resource Governor IO Control
        ◦ Demo: Resource Governor IO Control DMV
        ◦ Demo: Resource Governor IO Control and Backup


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top