{"id":6362,"date":"2015-11-26T16:06:48","date_gmt":"2015-11-26T15:06:48","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/"},"modified":"2015-11-26T16:06:48","modified_gmt":"2015-11-26T15:06:48","slug":"sql-server-2016-ctp3-0-stretch-database-enhancements","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/","title":{"rendered":"SQL Server 2016 CTP3.0: Stretch Database enhancements"},"content":{"rendered":"<p>Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-ctp2-stretch-database-feature-part-1\/\">here<\/a> and <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-ctp2-stretch-database-feature-part-2\/\">here<\/a>.<br \/>\nWith the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog.<\/p>\n<p>&nbsp;<\/p>\n<p>In previous versions of SQL Server 2016 CTP 2.x, before to be allowed to Enable Stretch Database, you had to enable the &#8220;Remote Data Archive&#8221; option for the instance. For my new SQL Server CTP 3.0 instance, this option is for the moment disable:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5538\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch1.jpg\" alt=\"Stretch1\" width=\"300\" height=\"93\" \/><\/a><\/p>\n<p>It is now possible to Enable Stretch Database for individual table. Let\u2019s try if it works with this configuration:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5539\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch2.jpg\" alt=\"Stretch2\" width=\"300\" height=\"223\" \/><\/a><\/p>\n<p>The wizard to Enable Table for Stretch appears:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5540\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch3.jpg\" alt=\"Stretch3\" width=\"300\" height=\"278\" \/><\/a><\/p>\n<p>Follow this wizard and enter:<\/p>\n<ul>\n<li>SQL Server database credentials<\/li>\n<li>Select tables from your database that you want to stretch to Azure (for me table command_queue)<\/li>\n<\/ul>\n<p>During the validation of SQL Server settings, the first test will check if the instance is configured for Stretch Database, fires an information message telling you that the configuration has not been done for the moment and will be done by the wizard:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5531\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4.jpg\" alt=\"Stretch4\" width=\"300\" height=\"279\" \/><\/a><\/p>\n<p>The wizard will now run the deployment process:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5532\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch5.jpg\" alt=\"Stretch5\" width=\"300\" height=\"280\" \/><\/a><\/p>\n<p>When the deployment is finalized, a special icon in front of the database name in Management Studio changed in order to directly visualized database with Stretch Database functionality:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5533\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch6.jpg\" alt=\"Stretch6\" width=\"186\" height=\"110\" \/><\/a><\/p>\n<p>Another great add-on is the monitor screen, accessible from the instance properties:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch7.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5534\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch7.jpg\" alt=\"Stretch7\" width=\"300\" height=\"67\" \/><\/a><\/p>\n<p>The monitor screen gives an overview of:<\/p>\n<ul>\n<li>On-premise server information: server name, database name, locally allocated space<\/li>\n<li>Azure server information: server name, database name, service tier, server region, database storage cost (not yet available)<\/li>\n<li>State of the connection between on-premise and Azure servers<\/li>\n<li>Stretch configured tables: table name, migration state, eligible rows, local rows, Rows in Azure and Details (not yet available)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch8.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5535\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch8.jpg\" alt=\"Stretch8\" width=\"300\" height=\"192\" \/><\/a><\/p>\n<p>Here all Eligible rows have not already been transferred to Azure.<br \/>\nA way to check the data transfer is to use the Extended Events. In fact, an Extended Event Session named StretchDatabase_Health is automatically created and started in your instance where the Stretch Database functionality is enabled:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5536\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch9.jpg\" alt=\"Stretch9\" width=\"267\" height=\"190\" \/><\/a><\/p>\n<p>Per default those events are captured:<\/p>\n<ul>\n<li>stretch_database_disable_completed: Reports the completion of a ALTER DATABASE SET<br \/>\nREMOTE_DATA_ARCHIVE OFF command<\/li>\n<li>stretch_database_enable_completed: Reports the completion of a ALTER DATABASE SET<br \/>\nREMOTE_DATA_ARCHIVE ON command<\/li>\n<li>stretch_index_reconciliation_codegen_completed: Reports the completion of code generation for stretch remote index operation<\/li>\n<li>stretch_remote_index_execution_completed: Reports the completion of remote execution for the generated code for a stretched index<\/li>\n<li>stretch_table_codegen_completed: Reports the completion of code generation for a stretched table<\/li>\n<li>stretch_table_remote_creation_completed: Reports the completion of remote execution for the<br \/>\ngenerated code for a stretched table<\/li>\n<li>stretch_table_row_migration_event: Reports the completion of the migration of a batch of rows<\/li>\n<li>stretch_table_unprovision_completed: Reports the completion removal of local resources for<br \/>\na table that was unstretched<\/li>\n<li>stretch_table_validation_error: Reports the completion of validation for a table when the user<br \/>\nenables stretch<\/li>\n<\/ul>\n<p>Some others events can be added, following the complete list:<\/p>\n<ul>\n<li>stretch_codegen_errorlog: Reports the output from the code generator<\/li>\n<li>stretch_codegen_start: Reports the start of stretch code generation<\/li>\n<li>stretch_create_migration_proc_start: Reports the start of migration procedure creation<\/li>\n<li>stretch_create_remote_table_start: Reports the start of remote table creation<\/li>\n<li>stretch_create_update_trigger_start: Reports the start of create update trigger for remote data archive<br \/>\ntable<\/li>\n<li>stretch_index_update_step_completed: Reports the duration of a stretched index update operation<\/li>\n<li>stretch_database_events_submitted: Reports the completion telemetry transfer<\/li>\n<li>stretch_migration_debug_trace: Debug trace of stretch migration actions<\/li>\n<li>stretch_migration_queue_migration: Queue a packet for starting migration of the database and object<\/li>\n<li>stretch_migration_sp_stretch_get_batch_id: Call sp_stretch_get_batch_id<\/li>\n<li>stretch_migration_start_migration: Start migration of the database and object<\/li>\n<li>stretch_schema_queue_task: Reports when a packet is about to be queued for processing a schema task for the database and object<\/li>\n<li>stretch_schema_script_execution_completed: Reports the completion of stretch script execution during processing stretch schema task<\/li>\n<li>stretch_schema_script_execution_skipped: Reports the skipping of stretch script execution during processing stretch schema task<\/li>\n<li>stretch_schema_script_execution_start: Reports the start of stretch script execution during processing stretch schema task<\/li>\n<li>stretch_schema_task_failed: Reports the failure of a stretch schema function during the stretch schema task<\/li>\n<li>stretch_schema_task_start: Reports the start of stretch schema function during the stretch schema task<\/li>\n<li>stretch_schema_task_succeeded: Reports the successful completion of stretch schema function during the stretch schema task<\/li>\n<li>stretch_sync_metadata_start: Reports the start of metadata checks during the migration task<\/li>\n<li>stretch_table_provisioning_step_duration: Reports the duration of a stretched table provisioning<br \/>\noperation<\/li>\n<li>stretch_table_provisioning_step_completed: Reports the duration of a stretched table provisioning operation<\/li>\n<li>stretch_table_row_migration_results_event: Reports an error or completion of a successful<br \/>\nmigration of a number of batches of rows<\/li>\n<li>stretch_unprovision_table_start: Reports the start of stretch table un-provisioning<\/li>\n<\/ul>\n<p>An example of the stretch_table_row_migration_event shows:<\/p>\n<ul>\n<li>Number of row migrated per batch (5000)<\/li>\n<li>Duration in millisecond<\/li>\n<li>Error number and state<\/li>\n<li>Table and database id<\/li>\n<li>If the migration succeed<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5537\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch10.jpg\" alt=\"Stretch10\" width=\"300\" height=\"202\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Stretch Database is a new functionality and, as each new functionality, has some limitations that will decrease in the future.<br \/>\nNevertheless the ability to stretch individual tables from a database to Azure could help organizations to easily archive their data.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog. &nbsp; In previous versions of SQL Server 2016 CTP [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":6373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,48],"tags":[711,280,23,51,566,712,213],"type_dbi":[],"class_list":["post-6362","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","category-technology-survey","tag-ctp3-0","tag-database","tag-dba","tag-sql-server","tag-sql-server-2016","tag-stretch-database","tag-windows-azure"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 CTP3.0: Stretch Database enhancements - dbi Blog<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 CTP3.0 Stretch database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 CTP3.0: Stretch Database enhancements\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 CTP3.0 Stretch database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-26T15:06:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"728\" \/>\n\t<meta property=\"og:image:height\" content=\"678\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2016 CTP3.0: Stretch Database enhancements\",\"datePublished\":\"2015-11-26T15:06:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\"},\"wordCount\":921,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg\",\"keywords\":[\"CTP3.0\",\"database\",\"DBA\",\"SQL Server\",\"SQL Server 2016\",\"Stretch database\",\"Windows Azure\"],\"articleSection\":[\"Database management\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\",\"name\":\"SQL Server 2016 CTP3.0: Stretch Database enhancements - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg\",\"datePublished\":\"2015-11-26T15:06:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"SQL Server 2016 CTP3.0 Stretch database\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg\",\"width\":728,\"height\":678},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 CTP3.0: Stretch Database enhancements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016 CTP3.0: Stretch Database enhancements - dbi Blog","description":"SQL Server 2016 CTP3.0 Stretch database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 CTP3.0: Stretch Database enhancements","og_description":"SQL Server 2016 CTP3.0 Stretch database","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/","og_site_name":"dbi Blog","article_published_time":"2015-11-26T15:06:48+00:00","og_image":[{"width":728,"height":678,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2016 CTP3.0: Stretch Database enhancements","datePublished":"2015-11-26T15:06:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/"},"wordCount":921,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg","keywords":["CTP3.0","database","DBA","SQL Server","SQL Server 2016","Stretch database","Windows Azure"],"articleSection":["Database management","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/","name":"SQL Server 2016 CTP3.0: Stretch Database enhancements - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg","datePublished":"2015-11-26T15:06:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"SQL Server 2016 CTP3.0 Stretch database","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Stretch4-1.jpg","width":728,"height":678},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-ctp3-0-stretch-database-enhancements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 CTP3.0: Stretch Database enhancements"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6362"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6362\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6373"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6362"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}