{"id":41130,"date":"2025-10-22T11:04:11","date_gmt":"2025-10-22T09:04:11","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=41130"},"modified":"2025-10-22T11:04:14","modified_gmt":"2025-10-22T09:04:14","slug":"sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/","title":{"rendered":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?"},"content":{"rendered":"\n<p>The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it\u2019s good to come back to basis&#8230;<\/p>\n\n\n\n<p>How to begin? Read the documentation of course <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/functions\/serverproperty-transact-sql?view=sql-server-ver17\">here<\/a> but you will see a lot of informations&#8230;<\/p>\n\n\n\n<p>After reading the documentation, how to have the first useful information?<\/p>\n\n\n\n<p>The first information will be about the <strong>SQL Server installed<\/strong> like the server name, instance name, build and version with also some advanced information like last update date, the KB or CU.<\/p>\n\n\n\n<p>Here this first query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT  \n  SERVERPROPERTY('MachineName') AS &#091;Server_Name],\n  SERVERPROPERTY('InstanceName') AS &#091;Instance_Name], \n  SERVERPROPERTY('Edition') AS &#091;Edition],\n  SERVERPROPERTY('ProductVersion') AS &#091;Product_Version], \n  SERVERPROPERTY('ProductLevel') AS &#091;Product _Level],\n  SERVERPROPERTY('ProductBuild') AS &#091;Product _Build],\n   SERVERPROPERTY('ProductMajorVersion') AS &#091;Advanced_Product_ Major_Version],\n  SERVERPROPERTY('ProductMinorVersion') AS &#091;Advanced_Product_Minor_Version],\n   SERVERPROPERTY('ProductUpdateReference ') AS &#091;Advanced_KB_Version],\n  SERVERPROPERTY('ProductUpdateLevel') AS &#091;Advanced_Update _Level],\n  SERVERPROPERTY(' ResourceLastUpdateDateTime ') AS &#091;Advanced_Last_Update_Date]\n<\/code><\/pre>\n\n\n\n<p>Result of a test:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"263\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\" alt=\"\" class=\"wp-image-41131\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8-300x84.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8-768x215.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>I run all queries on my sql server container under Visual Studio Code and sql server 2025 CPT2.1.<\/p>\n\n\n\n<p>You can have more info about it here (<a href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-local-sql-server-container-without-docker-command\/\">dbi Blog<\/a>)<\/p>\n\n\n\n<p>After, some other useful information will be if the instance has <strong>features installed<\/strong> like Polybase or Full-Text seach but also some <strong>configuration<\/strong> like filestream or HA.<\/p>\n\n\n\n<p>&nbsp;Here the query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n  SERVERPROPERTY('MachineName') AS &#091;Server_Name],\n  SERVERPROPERTY('InstanceName') AS &#091;Instance_Name], \n  SERVERPROPERTY('IsPolyBaseInstalled') AS &#091;Is_Polybase_Installed],  \n  SERVERPROPERTY('IsFullTextInstalled') AS &#091;Is_Full-Text_Search_Installed],\n  SERVERPROPERTY('IsAdvancedAnalyticsInstalled') AS &#091;Is_Advanced_Analytics_Installed],\n  SERVERPROPERTY('FilestreamConfiguredLevel') AS &#091;is_Filestream_enabled],  \n  SERVERPROPERTY('IsBigDataCluster') AS &#091;Is_BigData_Cluster_enabled],\n  SERVERPROPERTY('IsClustered') AS &#091;Is_Clustered],  \n  SERVERPROPERTY('IsHadrEnabled') AS &#091;Is_HADR_enabled],\n   SERVERPROPERTY('IsTempDbMetadataMemoryOptimized') AS &#091;Is_TempDB_for_Memory_Optimized_Tables_Enabled],  \n  SERVERPROPERTY('IsXTPSupported') AS &#091;Is_IN_Memory_OLTP_Supported],\n  SERVERPROPERTY('IsExternalGovernanceEnabled') AS &#091;Is_External_Governance_Enabled];\n<\/code><\/pre>\n\n\n\n<p>Result of a test:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"242\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-9.png\" alt=\"\" class=\"wp-image-41132\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-9.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-9-300x77.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-9-768x198.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>You can notice that the last property is the External governance. This is linked to the &nbsp;<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/purview\/how-to-policies-data-owner-arc-sql-server\">Microsoft Purview access policies<\/a>. &nbsp;<\/p>\n\n\n\n<p>The next useful information will be about the <strong>security<\/strong>.<\/p>\n\n\n\n<p>Here the query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n  SERVERPROPERTY('MachineName') AS &#091;Server_Name],\n  SERVERPROPERTY('InstanceName') AS &#091;Instance_Name], \n  SERVERPROPERTY('IsIntegratedSecurityOnly') AS &#091;Is_Integrated_Security_Only],\n  SERVERPROPERTY('IsSingleUser') AS &#091;Is_Single_User],\n  SERVERPROPERTY('IsExternalAuthenticationOnly') AS &#091;s_External_Authentication_Only];\n<\/code><\/pre>\n\n\n\n<p>Result of a test:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"354\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-10.png\" alt=\"\" class=\"wp-image-41133\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-10.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-10-300x113.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-10-768x289.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>The External Authentication concerns the <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/authentication-azure-ad-only-authentication\">Microsoft Entra-only authentication<\/a>\u00a0 for Azure SQL Database &amp; Azure SQL Managed Instance. <\/p>\n\n\n\n<p>The last information package is the <strong>collation\/character set<\/strong> with this query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n  SERVERPROPERTY('MachineName') AS &#091;Server_Name],\n  SERVERPROPERTY('InstanceName') AS &#091;Instance_Name], \n  SERVERPROPERTY('Collation') AS &#091;Collation], \n  SERVERPROPERTY('LCID') AS &#091;Windows_Locale_Identifier], \n  SERVERPROPERTY('SqlCharSetName') AS &#091;SQL_Character_Set_Name], \n  SERVERPROPERTY('SqlSortOrderName') AS &#091;SQL_Sort_Order_Name];\n<\/code><\/pre>\n\n\n\n<p>Result of a test:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"191\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-11.png\" alt=\"\" class=\"wp-image-41134\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-11.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-11-300x95.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<p>To conclude, you have now in this blog <strong>4 useful queries to find information on the server level<\/strong>.<br>Don\u2019t hesitate to add your comments or give me other useful property that you use.!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it\u2019s good to come back to basis&#8230; How to begin? Read the documentation of course here but you will see a lot of informations&#8230; After reading the documentation, how to have the first useful information? The [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3271,229,198,99],"tags":[49,51],"type_dbi":[],"class_list":["post-41130","post","type-post","status-publish","format-standard","hentry","category-azure","category-database-administration-monitoring","category-database-management","category-sql-server","tag-microsoft","tag-sql-server"],"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: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way? - dbi Blog<\/title>\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-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?\" \/>\n<meta property=\"og:description\" content=\"The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it\u2019s good to come back to basis&#8230; How to begin? Read the documentation of course here but you will see a lot of informations&#8230; After reading the documentation, how to have the first useful information? The [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-22T09:04:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-22T09:04:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"263\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\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 Haby\" \/>\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\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?\",\"datePublished\":\"2025-10-22T09:04:11+00:00\",\"dateModified\":\"2025-10-22T09:04:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\"},\"wordCount\":274,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Azure\",\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\",\"name\":\"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\",\"datePublished\":\"2025-10-22T09:04:11+00:00\",\"dateModified\":\"2025-10-22T09:04:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png\",\"width\":940,\"height\":263},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?\"}]},{\"@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\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as 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. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way? - dbi Blog","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-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?","og_description":"The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it\u2019s good to come back to basis&#8230; How to begin? Read the documentation of course here but you will see a lot of informations&#8230; After reading the documentation, how to have the first useful information? The [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/","og_site_name":"dbi Blog","article_published_time":"2025-10-22T09:04:11+00:00","article_modified_time":"2025-10-22T09:04:14+00:00","og_image":[{"width":940,"height":263,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?","datePublished":"2025-10-22T09:04:11+00:00","dateModified":"2025-10-22T09:04:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/"},"wordCount":274,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png","keywords":["Microsoft","SQL Server"],"articleSection":["Azure","Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/","name":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png","datePublished":"2025-10-22T09:04:11+00:00","dateModified":"2025-10-22T09:04:14+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/10\/image-8.png","width":940,"height":263},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-do-you-know-how-to-use-serverproperty-function-in-a-useful-way\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Do you know how to use SERVERPROPERTY() \u00a0function in a useful way?"}]},{"@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\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as 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. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41130","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=41130"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41130\/revisions"}],"predecessor-version":[{"id":41136,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/41130\/revisions\/41136"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=41130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=41130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=41130"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=41130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}