{"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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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;&nbsp;<\/p>\n","protected":false},"author":21,"featured_media":6373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[1338,23,566,712],"class_list":["post-6362","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-azure","tag-dba","tag-sql-server-2016","tag-stretch-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 CTP3.0: Stretch Database enhancements - dbi services 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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/adf6293d8bc8a7a26490acfe2918b6d7\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2022\\\/04\\\/Stretch4-1.jpg\",\"keywords\":[\"Azure\",\"DBA\",\"SQL Server 2016\",\"Stretch database\"],\"articleSection\":[\"Database\"],\"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 services 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\\\/2022\\\/04\\\/Stretch4-1.jpg\",\"datePublished\":\"2015-11-26T15:06:48+00:00\",\"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\\\/2022\\\/04\\\/Stretch4-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/adf6293d8bc8a7a26490acfe2918b6d7\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/STS_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.\",\"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 services 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 services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/Stretch4-1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/adf6293d8bc8a7a26490acfe2918b6d7"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2022\/04\/Stretch4-1.jpg","keywords":["Azure","DBA","SQL Server 2016","Stretch database"],"articleSection":["Database"],"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 services 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\/2022\/04\/Stretch4-1.jpg","datePublished":"2015-11-26T15:06:48+00:00","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\/2022\/04\/Stretch4-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/adf6293d8bc8a7a26490acfe2918b6d7","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/10\/STS_web-min-scaled.jpg","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}