Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

SQL Server: Scaling SQL Server 2012 and 2014: Part 2

SQL Server: Scaling SQL Server 2012 and 2014: Part 2

1425
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn 150Edvicer reward coin150 coins = INR 150

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Why should you choose this course?

Description

Learn how to avoid configuration issues from the hardware to the database that can limit the scalability of a SQL Server 2012/2014 workload, along with features and design methodologies for scaling up and scaling out.

Syllabus

Introduction
What This Course Covers
Course Structure
Introduction
Statistics-related Database Properties
Recovery Model and Compatibility Level
Undesirable Database Properties
Miscellaneous Settings to Consider
Demo: Checking Database Properties
Database Filegroup Considerations
Database File Layout Considerations
Database File Size and Growth Settings
Demo: Finding Files That Have Percent Growth
Demo: Changing Database Properties with T-SQL
Module Summary
Introduction
Operating System Issues
Negotiated Versions of SMB
Lock Pages in Memory (LPIM)
Perform Volume Maintenance Tasks
Demo: Granting OS Rights to SQL Server
Windows Page File Size
Global Trace Flags
Tempdb Configuration Settings
Instance-level Configuration Settings
Demo: Changing Instance-level Configuration Settings with T-SQL
Best Practices for Performance and Scalability
Module Summary
Introduction
Common Storage Subsystem Issues
Common SQL Server Workload Types and I/O Access Patterns
Demo: I/O Related DMV Queries
Common DMV I/O Query Result Patterns
Sizing Your Storage Subsystem
Choosing Storage Types and Subsystem Design Tips
CrystalDiskMark 5.1 and Microsoft DiskSpd
Demo: CrystalDiskMark 5.1
Demo: Microsoft DiskSpd
Module Summary
Introduction
Common Hardware Issues
Key BIOS Settings
PCIe Throughput Limits
Power Management
BIOS Power Management and Using CPU-Z
Demo: Using CPU-Z
Demo: Windows Power Plan Setting
Processor Selection for SQL Server
Intel Tick-tock Release Strategy
Intel Processor Family Tree
Preferred Haswell-EP and Haswell-EX Processors
Module Summary
Introduction
Windows Server and SQL Server License Limits
Diminishing Returns of Scaling Up
Planning a Hardware Migration
Resist Temptation to Upgrade-in-place
Smoothly Migrating to New Hardware
Database Mirroring vs. Log Shipping
Module Summary
Introduction
SQL Server 2014 Availability Groups
Transactional Replication
Peer-to-peer Replication
Distributed Partitioned Views
Service-oriented Database Architecture (SODA)
Data Dependent Routing (DDR)
Scale Out Realities to Remember
Module Summary
Introduction
Buffer Pool Extensions
Demo: Buffer Pool Extensions
Resource Governor Enhancements
Demo: Resource Governor Enhancements
Clustered Columnstore Indexes
Demo: Clustered Columnstore Indexes
Delayed Durability
Demo: Delayed Durability
New Cardinality Estimator
Demo: New Cardinality Estimator
Module Summary
Where to Go Next and Course Summary

What others say about this course

FAQs

What is SQL?

Structured Query Language (SQL) is a domain-specific language designed for data management for RDBMS. SQL comes particularly handy in managing structured data and offers certain advantages, such as allowing the access of multiple records through a single command and eliminating the need to specify how to access a record. In simpler words, SQL provides tools to the programmer to define, control and manipulate data in a relational model including tables, rows, and columns.

What are the Prerequisites for learning SQL?

If you wish to learn SQL programming, know the prerequisites well for a smooth learning journey. SQL is a basic query language used primarily for databases, coming with no prerequisites as such. With a simple syntax, there aren't many specific requirements, but it would be helpful to learn database concepts, calculus theories, and basic RDBMS concepts. Once you get a hold of these concepts, you are good to go.

Why should you learn SQL?

SQL query is purely a text message application which can help you access data. SQL is used for most relational storage systems, and it is more of a query language than a programming language. Learning SQL helps the programmers in accessing data with greater efficiency through basic queries. It is predominantly effectual for data manipulation, and the data stored in SQL is dynamic, which means it can be manipulated and modified at any point of time using a set of basic queries. These features make SQL fully equipped to manage datasets of all shapes and sizes.

How can Edvicer help you find the best SQL courses?

Edvicer is a great place to learn SQL with a large number of SQL courses, both free and paid, and projects, both for practice and freelancing. Edvicer has helped a large number of people learn SQL online through the best courses from the top providers like Coursera, Udemy, Udacity, and Pluralsight.

What are the top jobs that I can get from learning SQL?

The top job profile for SQL experts are Dotnet Developer with an average salary of INR 5 LPA, Software Engineer with an average salary of INR 7 LPA, and Database Administrator with an average salary of INR 7 LPA. Get your career map for your skills here.

What can I learn after learning SQL?

After learning SQL, the top skills you can learn to open highest number of job profiles for you are Python, Java, and Data Analytics. The top skills that can get you jobs with highest salaries are Node.js, Data Mining, and Statistical Modeling

Write your review of SQL Server: Scaling SQL Server 2012 and 2014: Part 2

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer

30% off