SQL Server 2014 Learning Series
On 18th March 2014, Microsoft has announced RTM of SQL Server 2014. You can read the announcement here. On 1st April, the free download has made available for EVAL and Express Edition. Read here.
SQL Server 2014 Eval ISO download at http://technet.microsoft.com/en-US/evalcenter/dn205290
SQL 2014 Express is at http://msdn.microsoft.com/en-US/evalcenter/dn434042
Keeping in mind the enhancements introduced in SQL Server 2014, I have started learning series for SQL 2014 https://sqlserver-help.com/category/sql-2014-learning-series/. Since In-Memory OLTP is big topic by itself so separate series is written https://sqlserver-help.com/in-memory-oltp-series/
Blogs as of today:
- New Permission – Connect any database: https://sqlserver-help.com/2014/03/27/sql-2014-learning-series-1-new-permission-connect-any-database
- New Permission – Select All User Securables: https://sqlserver-help.com/2014/04/01/sql-2014-learning-series-2-new-permission-select-all-user-securables
- New Feature – Backup Encryption: https://sqlserver-help.com/2014/04/03/sql-2014-learning-series-3-new-feature-backup-encryption
- New Feature – Buffer Pool Extension: https://sqlserver-help.com/2014/04/08/sql-2014-learning-series-4-new-feature-buffer-pool-extension
- New Feature – Incremental Statistics (Part 1): https://sqlserver-help.com/2014/04/15/sql-2014-learning-series-5-new-feature-incremental-statistics
- New Feature – Incremental Statistics (Part 2): https://sqlserver-help.com/2014/04/17/sql-2014-learning-series-6-new-feature-incremental-statistics-part-2
- New Feature – Delayed Durability (Part 1): https://sqlserver-help.com/2014/05/01/sql-2014-learning-series-7new-feature-delayed-durability-part-1
- New Feature – Delayed Durability (Part 2): https://sqlserver-help.com/2014/05/13/sql-2014-learning-series-8-new-feature-delayed-durability-part-2
- New Feature – Resource Governor for IO (Part 1): https://sqlserver-help.com/2014/05/15/sql-2014-learning-series-9-new-feature-resource-governor-to-control-io-part-1
- New Feature – Resource Governor for IO (Part 2): https://sqlserver-help.com/2014/05/20/sql-2014-learning-series-10-new-feature-resource-governor-to-control-io-part-2
- New DMV – sys.dm_exec_query_profiles (Part 1) : https://sqlserver-help.com/2014/06/10/sql-2014-learning-series-11-new-dmv-sys-dm_exec_query_profiles-part-1
- New DMV – sys.dm_exec_query_profiles (Part 2) : https://sqlserver-help.com/2014/06/12/sql-2014-learning-series-12-new-dmv-sys-dm_exec_query_profiles-part-2
- New Feature – Managed Lock Priority (Part 1) : https://sqlserver-help.com/2014/06/17/sql-2014-learning-series-13-new-feature-managed-lock-priority-part-1
- New Feature – Managed Lock Priority (Part 2) : https://sqlserver-help.com/2014/06/19/sql-2014-learning-series-14-new-feature-managed-lock-priority-part-2
- New Feature – Managed Lock Priority (Part 3) : https://sqlserver-help.com/2014/06/24/sql-2014-learning-series-15-new-feature-managed-lock-priority-part-3
- New Feature – Single Partition Online Index Rebuild: https://sqlserver-help.com/2014/06/26/sql-2014-learning-series-16-new-feature-single-partition-online-index-rebuild-spoir
This page would be updated whenever I post new blog on SQL 2014 Learning Series.
Happy Learning
Leave a Reply