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

Scaling SQL Server 2012 - Part 1

Course Summary

When considering how to improve the scalability of a SQL Server workload, many people jump to the conclusion that scaling up or scaling out are the only answers. This course will show you that there are a huge number of things you can do to improve perfor


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Top Scalability Issues with SQL Server 2012
        ◦ Postponing the Scaling Decision
        ◦ Application Architecture and Design Issues
        ◦ Database Architecture and Design Issues
        ◦ Indexing Strategy and Maintenance
        ◦ Summary
        ◦ Course Structure
    ● Top Scalability Issues with SQL Server 2012
        ◦ Introduction
        ◦ Largest SQL Server Implementations and Your Nightmare
        ◦ Top Scalability Issues with SQL Server 2012
        ◦ Handling Scalability Issues
        ◦ Summary
        ◦ What is Next?
    ● Postponing the Scaling Decision
        ◦ Introduction
        ◦ Postponing the Scaling Decision
        ◦ Preventing Scalability Problems
        ◦ Finding Your Bottlenecks and Improving Them
        ◦ Using Diagnostic Tools to Find Bottlenecks
        ◦ Common Performance Bottlenecks
        ◦ Working with Consultants
        ◦ Working with Developers
        ◦ Working with Stakeholders
        ◦ Summary and Return on Investment
        ◦ What is Next?
    ● Application Architecture and Design
        ◦ Introduction
        ◦ Application Architecture and Design Issues
        ◦ Application Refactoring
        ◦ Overuse of ORM Code Generators
        ◦ Using Ad Hoc T-SQL from the Application
        ◦ Overuse of XML Data
        ◦ SQL Server Scalar User-Defined Functions
        ◦ Demo: T-SQL Scalar UDFs
        ◦ Too Much Business Logic in the Database
        ◦ Using DML Triggers for Application Logic
        ◦ Using CLR Assemblies for Application Logic
        ◦ Requesting Too Much Data from the Database
        ◦ User-Controlled, Long-Running Transactions
        ◦ Overuse of New SQL Server Features
        ◦ Doing Row-by-Agonizing-Row Processing
        ◦ Demo: Set-Based vs. RBAR Processing
        ◦ Not Having a Data Archiving Strategy
        ◦ Not Having a Reporting Strategy
        ◦ Not Using Middle-Tier Caching
        ◦ Common Middle-Tier Caching Tools
        ◦ Summary
        ◦ What is Next?
    ● Database Architecture and Design
        ◦ Introduction
        ◦ Database Architecture and Design Issues
        ◦ Using Default Database Properties
        ◦ Demo: Creating a New Database
        ◦ Data File Physical Layout
        ◦ Transaction Log File Physical Layout
        ◦ Transaction Log File Configuration
        ◦ Poor Database Normalization
        ◦ Lack of Check Constraints
        ◦ Lack of Foreign Keys
        ◦ Heap Tables
        ◦ Inappropriate Data Types
        ◦ Wide Data Types
        ◦ Poor Query Design (1)
        ◦ Demo: Implicit Conversions
        ◦ Poor Query Design (2)
        ◦ SQL Server is a Database Server!
        ◦ Not Using T-SQL Stored Procedures
        ◦ Overuse of ORM Query Generators
        ◦ Additional ORM Query Considerations
        ◦ Summary
        ◦ What is Next?


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