{"id":456,"date":"2013-10-27T14:29:18","date_gmt":"2013-10-27T14:29:18","guid":{"rendered":"http:\/\/ruirib.net\/blog\/?page_id=456"},"modified":"2014-01-15T00:06:33","modified_gmt":"2014-01-15T00:06:33","slug":"sql-server-2014-links","status":"publish","type":"page","link":"https:\/\/ruirib.net\/index.php\/resources\/sql-server-2014-links\/","title":{"rendered":"SQL Server 2014 Links"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p>This is an ongoing &#8220;project&#8221;. The idea is to have links related to SQL Server 2014 in a single place, for easy access &nbsp;and reference.<\/p>\r\n<ul>\r\n<li>In memory OLTP (Hekaton) related links:\r\n<ul>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/10\/15\/the-411-on-the-microsoft-sql-server-2014-in-memory-oltp-blog-series.aspx\">The 411 on the Microsoft SQL Server 2014 In-Memory OLTP Blog Series<\/a><\/li>\r\n<\/ul>\r\n<ul>\r\n<li><a href=\"http:\/\/sqlblog.coms\/kalen_delaney\/archive\/2013\/10\/20\/sql-server-2014-in-memory-oltp-hekaton-whitepaper-for-ctp2.aspx\">Geek City: SQL Server 2014 In-Memory OLTP (\u201cHekaton\u201d) Whitepaper for CTP2<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlblog.coms\/merrill_aldrich\/archive\/2013\/10\/21\/why-hekaton-in-memory-oltp-truly-is-revolutionary.aspx\">Why Hekaton In-Memory OLTP Truly is Revolutionary<\/a><\/li>\r\n<li><a href=\"https:\/\/www.simple-talk.coms\/2013\/10\/25\/what-the-hekaton\/\">What the Hekaton?<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/10\/16\/sql-server-2014-pushing-the-boundaries-of-in-memory-performance.aspx\">SQL Server 2014: Pushing the Boundaries of In-Memory Performance<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlmag.com\/Microsoft-inmemory-oltp-database-why-what-how\">Microsoft\u2019s In-Memory OLTP: Why, What, and How<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlmag.com\/sql-server-2014\/memory-oltp-engine-faqs\">In-Memory OLTP Engine FAQs<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/05\/in-memory-oltp-high-availability-for-databases-with-memory-optimized-tables.aspx\">In-Memory OLTP: High Availability for Databases with Memory-Optimized Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3065\/migrate-to-natively-compiled-sql-server-stored-procedures-for-hekaton\/\">Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/11\/new-in-memory-oltp-sample-for-sql-server-2014-ctp2.aspx\">New In-Memory OLTP Sample for SQL Server 2014 CTP2<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlservergeeks.coms\/kanchandba\/personal\/874\/sql-server-%E2%80%93-memory-optimization-advisor-sql-server-2014\">SQL Server \u2013 Memory Optimization Advisor, SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlservercentral.coms\/everyday-sql\/2013\/11\/12\/in-memory-oltp-and-the-identity-column\/\">In-Memory OLTP and the Identity Column<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/12\/sql-server-2014-in-memory-oltp-nonclustered-indexes-for-memory-optimized-tables.aspx\">SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.databasejournal.com\/features\/mssql\/overview-of-the-different-in-memory-oltp-index-types.html\">Overview of the Different In-Memory OLTP Index Types<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlservercentral.coms\/aschenbrenner\/2013\/06\/25\/first-steps-with-extreme-transaction-processing-hekaton\/\">First steps with Extreme Transaction Processing \u2013 Hekaton<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlskills.coms\/bobb\/thinking-about-hekaton-then-think-about-collations\/\">Thinking about Hekaton? Then think about collations<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3051\/overcoming-storage-speed-limitations-with-memoryoptimized-tables-for-sql-server\/\">Overcoming storage speed limitations with Memory-Optimized Tables for SQL Server<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3080\/workaround-for-lack-of-support-for-constraints-on-sql-server-memoryoptimized-tables\/\">Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlservercentral.coms\/aschenbrenner\/2013\/11\/23\/choose-your-hash-bucket-count-very-wisely-in-hekaton\/\">Choose your Hash Bucket Count very wisely in Hekaton!<\/a><\/li>\r\n<li><a href=\"http:\/s.msdn.com\/b\/sqlcat\/archive\/2013\/11\/13\/sql-server-2014-in-memory-oltp-discussions-at-pass-summit-2013.aspx\">SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/25\/boosting-transaction-performance-in-windows-azure-virtual-machines-with-in-memory-oltp.aspx\">Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlperformance.com\/2013\/11\/t-sql-queries\/hekaton-twist\">Hekaton with a twist: In-memory table-valued parameters<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3085\/updating-statistics-for-memoryoptimized-tables-in-sql-server\/\">Updating statistics for Memory-Optimized tables in SQL Server<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3106\/sql-server-2014-inmemory-oltp-architecture-and-data-storage\/\">SQL Server 2014 In-Memory OLTP Architecture and Data Storage<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3099\/understanding-sql-server-memoryoptimized-tables-hash-indexes\/\">Understanding SQL Server Memory-Optimized Tables Hash Indexes<\/a><\/li>\r\n<li><a href=\"http:\/\/dataidol.com\/tonyrogerson\/2014\/01\/06\/hekaton-in-memory-tables-hash-indexes\/\">Hekaton In-Memory Tables: HASH Indexes<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3104\/determine-bucketcount-for-hash-indexes-for-sql-server-memory-optimized-tables\/\">Determine BUCKET_COUNT for Hash Indexes for SQL Server Memory Optimized Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3107\/overview-of-applications-indexes-and-limitations-for-sql-server-2014-inmemory-oltp-tables\/\">Overview of Applications, Indexes and Limitations for SQL Server 2014 In-Memory OLTP Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3137\/getting-started-with-the-amr-tool-for-migration-to-sql-server-inmemory-oltp-tables\">Getting started with the AMR tool for migration to SQL Server In-memory OLTP Tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.databasejournal.com\/features\/mssql\/sql-server-2014-memory-optimization-advisor.html\">SQL Server 2014 Memory Optimization Advisor<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlskills.coms\/bobb\/transaction-dependencies-and-speculative-reads-with-memory-optimized-tables\/\">Transaction dependencies and speculative reads with memory-optimized tables<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlskills.coms\/bobb\/in-memory-oltp-read_set-write_set-and-scan_set\/\">In-memory OLTP \u2013 read_set, write_set, and scan_set<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2014\/01\/07\/sql-server-2014-in-memory-oltp-memory-optimized-table-types-and-table-variables.aspx\">SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables<\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Other subjects:\r\n<ul>\r\n<li><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39269\">Microsoft\u00ae SQL Server\u00ae 2014 CTP2 Product Guide<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlmag.com\/sql-server-2014\/new-features-sql-server-2014\">New features in SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb510411(v=sql.120).aspx\">What&#8217;s New (Database Engine)<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlblog.coms\/michael_zilberstein\/archive\/2013\/10\/21\/51415.aspx\">sys.dm_exec_query_profiles \u2013 FAQ<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2.aspx\">Backup and Restore Enhancements in SQL Server 2014 CTP2<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlmag.com\/sql-server-2014\/changes-sql-server-2014-alwayson-availability-groups\">Changes to SQL Server 2014 AlwaysOn Availability Groups<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlblog.coms\/michael_zilberstein\/archive\/2013\/11\/05\/51612.aspx\">Delayed Durability\u2013I start to like it!<\/a><\/li>\r\n<li><a href=\"http:\/s.msdn.com\/b\/igorpag\/archive\/2014\/01\/07\/wal-is-no-more-a-dogma-in-sql-server-2014.aspx\">WAL is no more a dogma in SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/colleenmorrow.com\/2014\/01\/13\/sql-server-2014-delayed-durability\/\">SQL Server 2014 \u2013 Delayed Durability<\/a><\/li>\r\n<li><a href=\"http:\/\/www.databasejournal.com\/features\/mssql\/new-enhanced-column-store-index-in-sql-server-2014-part-1.html\">New Enhanced Column Store Index in SQL Server 2014 \u2013 Part 1<\/a><\/li>\r\n<li><a href=\"http:\/\/www.databasejournal.com\/features\/mssql\/getting-started-with-columnstored-index-in-sql-server-2014-part-2.html\">Getting Started with Columnstore Index in SQL Server 2014 \u2013 Part 2<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlblog.coms\/michael_zilberstein\/archive\/2013\/12\/01\/51954.aspx\">Updateable columnstore index gotchas<\/a><\/li>\r\n<li><a href=\"http:\/\/rusanu.com\/2013\/12\/02\/sql-server-clustered-columnstore-tuple-mover\/\">SQL Server clustered columnstore Tuple Mover<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/07\/io-resource-governance-in-sql-server-2014.aspx\">IO Resource Governance in SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlpassion.at\/archive\/2014\/01\/14\/how-to-throttle-your-storage-with-resource-governor-in-sql-server-2014\/#comments\">How to throttle your Storage with Resource Governor in SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/stevestedman.com\/2013\/07\/enabling-transparent-data-encryption-on-sql-server-2014\/\">Enabling Transparent Data Encryption on SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/s.msdn.com\/b\/ssdt\/archive\/2013\/10\/25\/sql-server-data-tools-for-sql-server-2014-ctp2-is-available.aspx\">SQL Server Data Tools for SQL Server 2014 CTP2 is available<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/11\/13\/microsoft-sql-server-data-tools-update.aspx\">Microsoft SQL Server Data Tools Update<\/a><\/li>\r\n<li><a href=\"http:\/\/www.jamesserra.com\/archive\/2013\/09\/sql-server-2014-partition-improvements\/\">SQL Server 2014: Partition Improvements<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlservergeeks.coms\/kanchandba\/personal\/878\/sql-server-%E2%80%93-backup-encryption-sql-2014-ctp2\">SQL Server \u2013 Backup Encryption, SQL 2014 CTP2<\/a><\/li>\r\n<li><a href=\"http:\/\/sqlblog.coms\/greg_low\/archive\/2013\/11\/20\/sql-server-2014-hybrid-storing-data-files-in-azure-storage-bizarre-or-not.aspx\">SQL Server 2014 Hybrid: Storing data files in Azure storage &#8211; Bizarre or not?<\/a><\/li>\r\n<li><a href=\"http:\/\/searchsqlserver.techtarget.com\/feature\/SQL-Server-2014-overview-part-1-In-memory-cloud-integration-features\">SQL Server 2014 overview part 1: In-memory, cloud integration features<\/a><\/li>\r\n<li><a href=\"http:\/\/searchsqlserver.techtarget.com\/feature\/SQL-Server-2014-overview-part-2-Availability-and-scalability-features\">SQL Server 2014 overview part 2: Availability and scalability features<\/a><\/li>\r\n<li><a href=\"http:\/s.technet.com\/b\/dataplatforminsider\/archive\/2013\/12\/10\/sql-server-2014-hybrid-cloud-scenarios-migrating-on-premises-sql-server-to-windows-azure-virtual-machines.aspx\">SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines<\/a><\/li>\r\n<li><a href=\"http:\/\/www.microsoftvirtualacademy.com\/training-courses\/platform-for-hybrid-cloud-with-sql-server-2014-jump-start-#?fbid=tpsJ_CzEVXr\">Platform for Hybrid Cloud with SQL Server 2014 Jump Start<\/a><\/li>\r\n<li><a href=\"http:\/\/www.scarydba.com\/2013\/12\/17\/introducing-managed-backups-in-sql-server-2014\/\">Introducing Managed Backups in SQL Server 2014<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlperformance.com\/2013\/12\/t-sql-queries\/a-first-look-at-the-new-sql-server-cardinality-estimator\">A First Look at the New SQL Server Cardinality Estimator<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlskills.coms\/bobb\/correlating-sql-server-2014-cardinality-events-and-query-plan\/\">Correlating SQL Server 2014 cardinality events and query plan<\/a><\/li>\r\n<li><a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3111\/new-sql-server-2014-dynamic-management-views\/\">New SQL Server 2014 Dynamic Management Views<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlskills.coms\/bobb\/tracking-execution-stats-of-sql-server-2014-natively-compiled-sprocs\/\">Tracking execution stats of SQL Server 2014 natively-compiled sprocs<\/a><\/li>\r\n<li><a href=\"http:\/\/www.sqlpassion.at\/archive\/2014\/01\/02\/how-sql-server-2014-improves-online-operations-that-arent-online-operations\/\">How SQL Server 2014 improves Online Operations that aren\u2019t Online Operations<\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","protected":false},"excerpt":{"rendered":"This is an ongoing &#8220;project&#8221;. The idea is to have links related to SQL Server 2014 in a single place, for easy access &nbsp;and reference. In memory OLTP (Hekaton) related links: The 411 on the Microsoft SQL Server 2014 In-Memory OLTP Blog Series Geek City: SQL Server 2014 In-Memory OLTP (\u201cHekaton\u201d) Whitepaper for CTP2 Why&#8230;","protected":false},"author":1,"featured_media":0,"parent":471,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-456","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/pages\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":55,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/pages\/456\/revisions"}],"predecessor-version":[{"id":2047,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/pages\/456\/revisions\/2047"}],"up":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/pages\/471"}],"wp:attachment":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/media?parent=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}