{"id":564,"date":"2017-10-11T11:31:08","date_gmt":"2017-10-11T16:31:08","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=564"},"modified":"2017-10-11T11:31:08","modified_gmt":"2017-10-11T16:31:08","slug":"notes-sql-2017-azure-install-trace-flags","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/","title":{"rendered":"Notes From A SQL 2017 Azure Install &#8211; Trace Flags"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-full wp-image-569\" src=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg\" alt=\"\" width=\"800\" height=\"400\" srcset=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg 800w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure-300x150.jpg 300w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure-768x384.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/>Like most Database Administrators, I have a standard set of <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/database-console-commands\/dbcc-traceon-trace-flags-transact-sql\" target=\"_blank\" rel=\"noopener\">Trace Flags<\/a> that I implement on my SQL Servers.\u00a0 These are my tried and true trusty companions, used to help tune SQL Server to my specific needs.<\/p>\n<p>However, with SQL Server 2017 some of my long-time trusty Trace Flags are no longer needed.\u00a0 Below is a list of the Trace Flags that I\u00a0normally implement, with my notes on why they are no longer used in SQL Server 2017.\u00a0 Do not consider this a complete list of Trace Flag changes in SQL 2016 and SQL 2017, these are just the ones that I normally use.<\/p>\n<ul>\n<li><strong>Trace Flag 1117<\/strong> &#8211;\u00a0grow all data files at the same time so they remain the same size\n<ul>\n<li>Enabled in TempDB by default as of <a href=\"https:\/\/blogs.msdn.microsoft.com\/sql_server_team\/sql-server-2016-changes-in-default-behavior-for-autogrow-and-allocations-for-tempdb-and-user-databases\/\" target=\"_blank\" rel=\"noopener\">SQL Server 2016<\/a>;<\/li>\n<li>Now has to be specified on individual file groups via ALTER DATABASE;\n<ul>\n<li><em>ALTER DATABASE mydb MODIFY FILEGROUP [PRIMARY] AUTOGROW_ALL_FILES<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong>Trace Flag 1118<\/strong> &#8211;\u00a0always allocate full extents\n<ul>\n<li>Enabled in TempDB by default as of <a href=\"https:\/\/blogs.msdn.microsoft.com\/sql_server_team\/sql-server-2016-changes-in-default-behavior-for-autogrow-and-allocations-for-tempdb-and-user-databases\/\" target=\"_blank\" rel=\"noopener\">SQL Server 2016<\/a>;<\/li>\n<li>Replaced by a new DATABASE setting \u2013 MIXED_PAGE_ALLOCATION<\/li>\n<li>Now has to be controlled via ALTER DATABASE;\n<ul>\n<li><em>ALTER DATABASE &lt;dbname&gt; SET MIXED_PAGE_ALLOCATION { ON | OFF }<\/em><\/li>\n<\/ul>\n<ul>\n<li>Default value of the MIXED_PAGE_ALLOCATION is <strong>OFF<\/strong> meaning allocations in the database will use uniform extents.\u00a0 This setting is opposite in behavior of the Trace Flag (i.e. TF 1118 OFF and MIXED_PAGE_ALLOCATION ON provide the same behavior).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong><strong><strong>Trace Flag 2371<\/strong><span style=\"font-weight: normal;\">\u00a0&#8211;\u00a0control when the query optimizer generates autostats on a table<\/span><\/strong><\/strong>\n<ul style=\"margin-bottom: 0px; font-weight: normal;\">\n<li>For databases with compatibility level 130 you no longer have to enable trace flag 2371 because the corresponding behavior is enabled by default. (<a href=\"https:\/\/support.microsoft.com\/en-us\/help\/2754171\/controlling-autostat-auto-update-statistics-behavior-in-sql-server\" target=\"_blank\" rel=\"noopener\">Microsoft Support Doc<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Trace Flag 4199<\/strong>\u00a0&#8211;\u00a0Enables query optimizer changes that are released in SQL Server Cumulative Updates and Service Packs.\n<ul>\n<li>Now has to be controlled via <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-scoped-configuration-transact-sql\" target=\"_blank\" rel=\"noopener\">ALTER DATABASE SCOPED CONFIGURATION<\/a><\/li>\n<li>Enables or disables query optimization hotfixes regardless of the compatibility level of the database. The default is OFF. This is equivalent to enabling Trace Flag 4199.\n<ul>\n<li>ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = { ON | OFF | PRIMARY }<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong>Trace Flag 9481<\/strong> &#8211;\u00a0Enables you to set the query optimizer cardinality estimation model to the SQL Server 2012 and earlier versions\n<ul>\n<li>Now has to be controlled via <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-scoped-configuration-transact-sql\" target=\"_blank\" rel=\"noopener\">ALTER DATABASE SCOPED CONFIGURATION<\/a>\n<ul>\n<li>Enables you to set the query optimizer cardinality estimation model to the SQL Server 2012 and earlier version independent of the compatibility level of the database. The default is OFF, which sets the query optimizer cardinality estimation model based on the compatibility level of the database. Setting this to ON is equivalent to enabling Trace Flag 9481.<\/li>\n<li>ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = { ON | OFF | PRIMARY }<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Additional notes on Trace Flags 1117 &amp; 1118:<\/strong><\/p>\n<p>The first server that I spun up, I used an Azure SQL 2017 template.\u00a0 In it Trace Flags 1117 and 1118 are enabled as startup parameters in SQL Server Configuration Manager, even though they don&#8217;t do anything in SQL 2017.\u00a0 You may want to manually remove them.<\/p>\n<p><em>This post is part of an ongoing series of blog posts related to my\u00a0<a href=\"https:\/\/sqlnuggets.com\/blog\/tag\/azure-migration\/\">Azure SQL Server 2017 Migration<\/a>.<\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers.\u00a0 These are my tried and true trusty companions, used to help &#8230;<\/p>\n","protected":false},"author":2,"featured_media":569,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[54,28],"tags":[55,56],"class_list":["post-564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-db-engine","tag-azure-migration","tag-trace-flags"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers.\u00a0 These are my tried and true trusty companions, used to help ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-11T16:31:08+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Notes From A SQL 2017 Azure Install &#8211; Trace Flags\",\"datePublished\":\"2017-10-11T16:31:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/\"},\"wordCount\":507,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/Cloud-Azure.jpg\",\"keywords\":[\"Azure Migration\",\"Trace Flags\"],\"articleSection\":[\"Azure\",\"DB Engine\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/\",\"name\":\"Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/Cloud-Azure.jpg\",\"datePublished\":\"2017-10-11T16:31:08+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/Cloud-Azure.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/Cloud-Azure.jpg\",\"width\":800,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/notes-sql-2017-azure-install-trace-flags\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Notes From A SQL 2017 Azure Install &#8211; Trace Flags\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets","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":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/","og_locale":"en_US","og_type":"article","og_title":"Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets","og_description":"Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers.\u00a0 These are my tried and true trusty companions, used to help ...","og_url":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/","og_site_name":"SQL Nuggets","article_published_time":"2017-10-11T16:31:08+00:00","og_image":[{"width":800,"height":400,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","type":"image\/jpeg"}],"author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Notes From A SQL 2017 Azure Install &#8211; Trace Flags","datePublished":"2017-10-11T16:31:08+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/"},"wordCount":507,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","keywords":["Azure Migration","Trace Flags"],"articleSection":["Azure","DB Engine"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/","url":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/","name":"Notes From A SQL 2017 Azure Install - Trace Flags - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","datePublished":"2017-10-11T16:31:08+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","width":800,"height":400},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/notes-sql-2017-azure-install-trace-flags\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Notes From A SQL 2017 Azure Install &#8211; Trace Flags"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-96","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":567,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install\/","url_meta":{"origin":564,"position":0},"title":"Notes From A SQL 2017 Azure Install","author":"Eric Cobb","date":"October 11, 2017","format":false,"excerpt":"Now that SQL Server 2017 is out it's time for everyone to start migrating to it, right?\u00a0 RIGHT? Well, in my case, the answer actually is \"Yes!\"\u00a0 At my day job we have started a project to move from our current data center into Azure.\u00a0 While we originally planned to\u2026","rel":"","context":"In &quot;Azure&quot;","block_context":{"text":"Azure","link":"https:\/\/sqlnuggets.com\/category\/azure\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":613,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-using-load-balancer-availability-group-listener\/","url_meta":{"origin":564,"position":1},"title":"Notes From A SQL 2017 Azure Install \u2013 Using A Load Balancer As An Availability Group Listener","author":"Eric Cobb","date":"November 9, 2017","format":false,"excerpt":"When setting up\u00a0SQL Server Availability Groups on Azure virtual machines, one of the requirements is that you use a load balancer for your Availability Group listener.\u00a0\u00a0The load balancer stores the IP address for the listener, and then you configure the cluster to use the IP address from the load balancer\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":621,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-using-cloud-witness-availability-group\/","url_meta":{"origin":564,"position":2},"title":"Notes From A SQL 2017 Azure Install \u2013 Using A Cloud Witness With An Availability Group","author":"Eric Cobb","date":"December 14, 2017","format":false,"excerpt":"As I build out my new SQL Server 2017 Availability Group in Azure, running on Windows 2016, I'm wanting to leverage some of the new technologies available. I've already written about using Group Managed Service Accounts and an Azure Load Balancer Witness for an Availability Group.\u00a0 Another one of those\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":600,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-using-group-managed-service-accounts\/","url_meta":{"origin":564,"position":3},"title":"Notes From A SQL 2017 Azure Install &#8211; Using Group Managed Service Accounts","author":"Eric Cobb","date":"November 7, 2017","format":false,"excerpt":"One of the new features that I'm excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use\u00a0Group Managed Service Accounts, or \"gMSA\" for short.\u00a0 This isn't really a new feature, I believe it was first made available for SQL Server 2014 running on Windows\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":702,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-automatic-seeding-availability-group-tde-database\/","url_meta":{"origin":564,"position":4},"title":"Notes From A SQL 2017 Azure Install \u2013 Automatic Seeding Of An Availability Group TDE Database","author":"Eric Cobb","date":"February 13, 2018","format":false,"excerpt":"One of the neat features introduced with SQL Server 2016 was the automatic seeding of availability groups.\u00a0 And while it seems to work pretty well in most cases, if you are using TDE with your databases then all bets are off!\u00a0 Here's an article from the folks over at\u00a0Brent Ozar\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":829,"url":"https:\/\/sqlnuggets.com\/notes-from-a-sql-2017-azure-install-availability-group-nodes-across-multiple-azure-regions\/","url_meta":{"origin":564,"position":5},"title":"Notes From A SQL 2017 Azure Install \u2013 Availability Group Nodes Across Multiple Azure Regions","author":"Eric Cobb","date":"June 26, 2018","format":false,"excerpt":"One of the really great things about Azure is the capability to easily create servers in other data centers, in other parts of the country or world (referred to as \"regions\" in Azure).\u00a0 Couple that with SQL Server's Always On Availability Groups, and you've got the ingredients for a good\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=564"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/564\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/569"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}