Zero to Hero with
SQL Server 2014 http://goo.gl/NaHkPa
Designing Database Solutions for
SQL Server https://goo.gl/EMbg0c
Modern Web Platform Tutorials
Course 5 Hours https://goo.gl/HNVxUn
Upgrading to
Microsoft SQL Server 2014
https://goo.gl/A08S7h
SQL Server 2014 Tutorial: Updating your
Database Management Skills
https://goo.gl/ayl1Od
Mission Critical Performance with SQL Server 2014
https://goo.gl/fPoUVU
Visual Studio Online Tutorials For
Beginners
http://buff.ly/1COOnCN
Take this SQL Server 2014 course, and get the details on data warehousing and security enhancements.
Find out about columnstore index and how it accelerates the execution of data warehouse queries by up to 100x order of magnitude, while achieving significant (commonly 10x) data compression.
Hear about two big changes that impact query plans in data warehousing applications using a re-architected cardinality estimator and a new way to manage statistics on a large table.
Finally, explore separation of duties (SoD) in SQL Server, in terms of business needs, plus roles and permissions.
Instructors |
Sunil Agarwal –
Microsoft Principal Program Manager, SQL Server;
Vijay Natarajan - Microsoft
Senior Product Planner, SQL Server
Business Rationale
Hear about the business rationale for using columnstore index for your data warehouse workloads.
Columnstore Architecture
Explore how data is structured in the columnstore index to achieve high data compression, and look at the supporting
T-SQL statements.
Query Performance
Discover how
SQL provides better performance (by order of magnitude) for queries running on columnstore index.
Columnstore
Index Deep Dive
Find out about the columnstore index functionality introduced in SQL Server 2014, along with its limitations.
SQL Server 2014: Columnstore Index
Hear a description of the updateable clustered columnstore index introduced in SQL Server 2014, including improvements for better data compression and query performance.
Materialized Views and
Concurrency
Learn about the concurrency of
Update/
Delete/
Insert and
Select operations, and hear about using the materialized view to enforce uniqueness and to improve query performance for key lookup and short range scans.
Availability and Supportability
Get a high-level overview of availability and supportability.
Background on SQL Server Query
Optimizer (QO)
Find background information on how query optimizer uses column statistics and cardinality estimates to create an optimized query plan.
New Cardinality Estimator (CE)
Take a deep dive into the new cardinality estimator in SQL Server 2014.
Incremental
Statistics
Hear how to create incremental statistics for updating a partitioned table.
Implementing
Separation of Duties (SoD) in SQL Server
Explore the common business need for implementing separation of duties (SoD).
Principles &
Concepts
Get a high-level overview of SQL Server principles and concepts used to implement SoD.
Implementing SoD in SQL Server
Find a brief introduction to implementing SoD for different user roles in an organization.
If you feel useful for you and for everyone, please share it!
Source via: Channel9 -
MVA
------
Subscribe: http://goo.gl/gA1NLZ
Facebook: http://goo.gl/oEk624
Group: http://goo.gl/xPdeEX
Google+: http://goo.gl/iGZzZX
Twitter: http://goo.gl/PNRtC8
About &
Contact: http://goo.gl/JAolqj
- published: 30 Aug 2015
- views: 1510