{"id":3057,"date":"2021-12-06T08:00:00","date_gmt":"2021-12-06T05:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=3057"},"modified":"2025-09-12T00:48:39","modified_gmt":"2025-09-11T21:48:39","slug":"pos-vriskoyme-ti-charaktiristika-echei","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-ti-charaktiristika-echei\/","title":{"rendered":"How do we find what features each SQL Server instance has?"},"content":{"rendered":"<p>In this article we will see a query that I have made so that we can easily find the specs of each SQL Server instance. This query can run in any version without needing any conversion as it is dynamic.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What can we see through this query?<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Server name with the door<\/li>\n\n\n\n<li>What <a href=\"https:\/\/docs.microsoft.com\/en-us\/troubleshoot\/sql\/general\/determine-version-edition-update-level\" target=\"_blank\" rel=\"noreferrer noopener\">version<\/a> is<\/li>\n\n\n\n<li>Which patch is installed<\/li>\n\n\n\n<li>The server collation<\/li>\n\n\n\n<li>The CPU number<\/li>\n\n\n\n<li>The Physical RAM that the machine has and the Max-Min memory that we have configured for the instance<\/li>\n\n\n\n<li>The average CPU load of the last hour through the default extended event that SQL Server has installed <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/extended-events\/use-the-system-health-session?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">System Health<\/a><\/li>\n\n\n\n<li>The total size of the databases (Data and Log files)<\/li>\n\n\n\n<li>When was the last instance start-up?<\/li>\n\n\n\n<li>If it is enabled <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/diagnostic-connection-for-database-administrators?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DAC<\/a><\/li>\n\n\n\n<li>The price we have set for <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Max DOP<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/blocked-process-threshold-server-configuration-option?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">blocked process threshold<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/configure-the-cost-threshold-for-parallelism-server-configuration-option?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">cost threshold for parallelism<\/a><\/li>\n\n\n\n<li>Performance counters such as <strong><em>Page Life Expectancy<\/em><\/strong>, the <strong><em>Buffer cache hit ratio<\/em><\/strong> and other.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">But there is a problem<\/h2>\n\n\n\n<p>As the field to find the size of RAM on the machine changed in the newer versions its name from <em><strong>physical_memory_in_bytes<\/strong><\/em> in <em><strong>physical_memory_kb<\/strong><\/em> in the view <em><strong>sys.configurations<\/strong><\/em> the query must be written dynamically. That is, to run a different query depending on the version we have.<\/p>\n\n\n\n<p>Along with this change came the addition of <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-hadr-database-replica-states-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">availability groups<\/a>. So I just check if this object exists and one of the two queries runs accordingly. Alternatively, of course, we can look at it <em>ResourceVersion<\/em> if it is before version 11 (<em>SQL Server 2012<\/em>).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The query<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">set nocount on\nSET QUOTED_IDENTIFIER ON;\nGO\ndeclare\n@query1 varchar(max),\n@query2 varchar(max),\n@final varchar(max)\n\nset @query1 = 'SELECT\n @@servername AS [ServerName],\n (select distinct top 1 local_tcp_port from sys.dm_exec_connections where local_tcp_port is not null) as Port,\n   CASE \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''8%'' THEN ''SQL2000''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''9%'' THEN ''SQL2005''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''10.0%'' THEN ''SQL2008''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''10.5%'' THEN ''SQL2008 R2''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''11%'' THEN ''SQL2012''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''12%'' THEN ''SQL2014''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''13%'' THEN ''SQL2016''    \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''14%'' THEN ''SQL2017'' \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''15%'' THEN ''SQL2019'' \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''16%'' THEN ''SQL2022'' \n     ELSE ''unknown''\n  END AS MajorVersion,\n SERVERPROPERTY(''Edition'') AS [Edition],SERVERPROPERTY(''ProductVersion'') AS ProductVersion,SERVERPROPERTY(''ProductLevel'') AS ProductLevel,SERVERPROPERTY(''ProductUpdateLevel'') AS ProductUpdateLevel\n,SERVERPROPERTY(''Collation'') as [Server Collation] \n,cpu_count AS [Number of Logical CPU]\n--,hyperthread_ratio\n--,cpu_count\/hyperthread_ratio AS [Number of Physical CPU]\n,physical_memory_in_bytes\/1024\/1024\/1024  as [Physical Memory (GB)]\n,(SELECT cast(value_in_use as integer)\/1024\nFROM sys.configurations\nWHERE name = ''max server memory (MB)'') as [Max Instance memory GB]\n,(SELECT cast(value_in_use as integer)\/1024\nFROM sys.configurations\nWHERE name = ''min server memory (MB)'') as [Min Instance memory GB]\n,(select CAST( ((SUM(cast(size as bigint))* 8) \/ 1024.0 \/ 1024.0) as DECIMAL(18,2)) as [Total Data Size (GB)] from sys.master_files where type_desc = ''ROWS'') as [Total Data Size (GB)]\n,(select CAST( ((SUM(cast(size as bigint))* 8) \/ 1024.0 \/ 1024.0) as DECIMAL(18,2)) as [Total Log Size (GB)] from sys.master_files where type_desc = ''LOG'') as [Total Log Size (GB)]\n,(SELECT \n                        100-AVG(record.value(''(.\/Record\/SchedulerMonitorEvent\/SystemHealth\/SystemIdle)[1]'', ''INT'') )\n          FROM ( \n                        SELECT  top 60 CONVERT(xml, record) AS [record] \n                        FROM sys.dm_os_ring_buffers \n                        WHERE ring_buffer_type = N''RING_BUFFER_SCHEDULER_MONITOR''\n                        AND record LIKE ''%&lt;SystemHealth>%''\n\t\t\torder by timestamp desc) AS x )[AVG CPU Load Last Hour],\n(select cntr_value from sys.dm_os_performance_counters\nwhere counter_name =''Page life expectancy'' and object_name like ''%Buffer Manager%'') as [Page Life Expectancy],\n(select cntr_value from sys.dm_os_performance_counters\nwhere counter_name =''Memory Grants Pending'' and object_name like ''%Buffer Manager%'') as [Memory Grants Pending],\n(SELECT ((a.cntr_value * 100) \/ b.cntr_value) as Value FROM sys.dm_os_performance_counters  a\nJOIN (SELECT cntr_value, OBJECT_NAME FROM sys.dm_os_performance_counters WHERE counter_name = ''Buffer cache hit ratio base'' AND OBJECT_NAME LIKE ''%:Buffer Manager%'') b ON  a.OBJECT_NAME = b.OBJECT_NAME\nWHERE a.counter_name = ''Buffer cache hit ratio'' AND a.OBJECT_NAME LIKE ''%:Buffer Manager%'') as [Buffer cache hit ratio],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2)) as value  from sys.dm_os_performance_counters\nwhere counter_name = ''Batch Requests\/sec'') as [AVG BatchRequests\/sec], \n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2)) as Value from sys.dm_os_performance_counters\nwhere counter_name = ''SQL Compilations\/sec'') as [AVG SQL Compilations\/sec],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2))  as Value from sys.dm_os_performance_counters\nwhere counter_name = ''SQL Re-Compilations\/sec'') as [AVG SQL Re-Compilations\/sec],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2))  as Value from sys.dm_os_performance_counters\nwhere counter_name = ''Page Splits\/sec'') as [AVG Page Splits\/sec],\nsqlserver_start_time as [SQL Server Start Time]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''remote admin connections'') as [remote admin connections]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''blocked process threshold (s)'') as [blocked proccess threshold]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''max degree of parallelism'') as [max degree of parallelism]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''cost threshold for parallelism'') as [cost threshold for parallelism]\nFROM sys.dm_os_sys_info  OPTION (RECOMPILE)'\n\n\n\n\nset @query2 = 'SELECT\n @@servername AS [ServerName],\n (select distinct top 1 local_tcp_port from sys.dm_exec_connections where local_tcp_port is not null) as Port,\n   CASE \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''8%'' THEN ''SQL2000''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''9%'' THEN ''SQL2005''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''10.0%'' THEN ''SQL2008''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''10.5%'' THEN ''SQL2008 R2''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''11%'' THEN ''SQL2012''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''12%'' THEN ''SQL2014''\n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''13%'' THEN ''SQL2016''    \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''14%'' THEN ''SQL2017'' \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''15%'' THEN ''SQL2019'' \n     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY (''productversion'')) like ''16%'' THEN ''SQL2022'' \n     ELSE ''unknown''\n  END AS MajorVersion,\n SERVERPROPERTY(''Edition'') AS [Edition],SERVERPROPERTY(''ProductVersion'') AS ProductVersion,SERVERPROPERTY(''ProductLevel'') AS ProductLevel,SERVERPROPERTY(''ProductUpdateLevel'') AS ProductUpdateLevel\n,SERVERPROPERTY(''Collation'') as [Server Collation] \n,cpu_count AS [Number of Logical CPU]\n--,hyperthread_ratio\n--,cpu_count\/hyperthread_ratio AS [Number of Physical CPU]\n,physical_memory_kb\/1024\/1024 as [Physical Memory (GB)]\n,(SELECT cast(value_in_use as integer)\/1024\nFROM sys.configurations\nWHERE name = ''max server memory (MB)'') as [Max Instance memory GB]\n,(SELECT cast(value_in_use as integer)\/1024\nFROM sys.configurations\nWHERE name = ''min server memory (MB)'') as [Min Instance memory GB]\n,(select CAST( ((SUM(cast(size as bigint))* 8) \/ 1024.0 \/ 1024.0) as DECIMAL(18,2)) as [Total Data Size (GB)] from sys.master_files where type_desc = ''ROWS'') as [Total Data Size (GB)]\n,(select CAST( ((SUM(cast(size as bigint))* 8) \/ 1024.0 \/ 1024.0) as DECIMAL(18,2)) as [Total Log Size (GB)] from sys.master_files where type_desc = ''LOG'') as [Total Log Size (GB)]\n,\n   (SELECT \n                        100-AVG(record.value(''(.\/Record\/SchedulerMonitorEvent\/SystemHealth\/SystemIdle)[1]'', ''INT'') )\n          FROM ( \n                        SELECT top 60 CONVERT(xml, record) AS [record] \n                        FROM sys.dm_os_ring_buffers \n                        WHERE ring_buffer_type = N''RING_BUFFER_SCHEDULER_MONITOR''\n                        AND record LIKE ''%&lt;SystemHealth>%''\n\t\t\torder by timestamp desc) AS x )[AVG CPU Load Last Hour],\n(select cntr_value from sys.dm_os_performance_counters\nwhere counter_name =''Page life expectancy'' and object_name like ''%Buffer Manager%'') as [Page Life Expectancy],\n(select cntr_value from sys.dm_os_performance_counters\nwhere counter_name =''Memory Grants Pending'' and object_name like ''%Buffer Manager%'') as [Memory Grants Pending],\n(SELECT ((a.cntr_value * 100) \/ b.cntr_value) as Value FROM sys.dm_os_performance_counters  a\nJOIN (SELECT cntr_value, OBJECT_NAME FROM sys.dm_os_performance_counters WHERE counter_name = ''Buffer cache hit ratio base'' AND OBJECT_NAME LIKE ''%:Buffer Manager%'') b ON  a.OBJECT_NAME = b.OBJECT_NAME\nWHERE a.counter_name = ''Buffer cache hit ratio'' AND a.OBJECT_NAME LIKE ''%:Buffer Manager%'') as [Buffer cache hit ratio],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2)) as value  from sys.dm_os_performance_counters\nwhere counter_name = ''Batch Requests\/sec'') as [AVG BatchRequests\/sec], \n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2)) as Value from sys.dm_os_performance_counters\nwhere counter_name = ''SQL Compilations\/sec'') as [AVG SQL Compilations\/sec],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2))  as Value from sys.dm_os_performance_counters\nwhere counter_name = ''SQL Re-Compilations\/sec'') as [AVG SQL Re-Compilations\/sec],\n(select Cast(cast(cntr_value as float)\/(SELECT cast (DATEDIFF(s, sqlserver_start_time, GETDATE()) as float) FROM sys.dm_os_sys_info) as decimal (10,2))  as Value from sys.dm_os_performance_counters\nwhere counter_name = ''Page Splits\/sec'') as [AVG Page Splits\/sec],\nsqlserver_start_time as [SQL Server Start Time]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''remote admin connections'') as [remote admin connections]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''blocked process threshold (s)'') as [blocked proccess threshold]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''max degree of parallelism'') as [max degree of parallelism]\n,(SELECT value_in_use\nFROM sys.configurations\nWHERE name = ''cost threshold for parallelism'') as [cost threshold for parallelism]\nFROM sys.dm_os_sys_info  OPTION (RECOMPILE)'\n\n\nIF NOT EXISTS (SELECT 1\n           FROM sys.system_objects WITH (NOLOCK)\n           WHERE NAME='dm_hadr_database_replica_states') \nbegin set @final = @query1 end\nelse \nbegin set @final = @query2 end\n\n\nexec (@final)\n\n\n\n\n\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>The result appears as we see below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"115\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-04-1024x115.png\" alt=\"\" class=\"wp-image-3065\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-04-1024x115.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-04-300x34.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-04-768x86.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-04.png 1204w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">01<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How can we run it on all the instances we have?<\/h2>\n\n\n\n<p>The easiest way is to have it set to <em>SQL Server Management Studio<\/em> all our connections to the instances and run the query on all of them together.<\/p>\n\n\n\n<p>To do this we go to <em><strong>View<\/strong><\/em>, <strong><em>Registered Servers<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"607\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-01.png\" alt=\"\" class=\"wp-image-3058\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-01.png 427w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-01-211x300.png 211w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<p>There we choose under the <em><strong>Database Engine<\/strong><\/em>, right click on <em><strong>Local Server Groups<\/strong><\/em> and we press on <strong><em>New Server Registration\u2026<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"428\" height=\"500\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02.png\" alt=\"\" class=\"wp-image-3059\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02.png 428w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02-257x300.png 257w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><figcaption class=\"wp-element-caption\">03<\/figcaption><\/figure>\n\n\n\n<p>This is how we start filling all the servers we have. We only need the ServerName with its port and the credentials we connect to:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"592\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-06.png\" alt=\"\" class=\"wp-image-3068\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-06.png 532w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-06-270x300.png 270w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/><figcaption class=\"wp-element-caption\">04<\/figcaption><\/figure>\n\n\n\n<p>After adding the ones we want, we simply right-click on the folder we added them to (Local Server Groups) and <strong><em>New Query<\/em><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"428\" height=\"500\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02.png\" alt=\"\" class=\"wp-image-3059\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02.png 428w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-02-257x300.png 257w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><figcaption class=\"wp-element-caption\">05<\/figcaption><\/figure>\n\n\n\n<p>By adding the query to this new window and executing it, it will run us in a result set all the information we want:<\/p>\n\n\n\n<p><em>*Because the machine I ran the query on didn&#039;t have access to other instances, I just went through the registered servers three times the same for the example.<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"124\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-05-1024x124.png\" alt=\"\" class=\"wp-image-3063\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-05-1024x124.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-05-300x36.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-05-768x93.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/03\/sy-05.png 1276w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">06<\/figcaption><\/figure>","protected":false},"excerpt":{"rendered":"<p>In this article we will see a query that I have made so that we can easily find the specs of each SQL Server instance. This query can run in any version without needing any conversion as it is dynamic. What can we see through this query But there is a problem As [\u2026]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15],"tags":[29,23,30,6],"class_list":["post-3057","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","tag-databases","tag-microsoft","tag-rdbms","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr<\/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.dataplatform.gr\/en\/pos-vriskoyme-ti-charaktiristika-echei\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03ad\u03bd\u03b1 query \u03c0\u03bf\u03c5 \u03ad\u03c7\u03c9 \u03c6\u03c4\u03b9\u03ac\u03be\u03b5\u03b9 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c4\u03b1 specs \u03c4\u03bf\u03c5 \u03ba\u03ac\u03b8\u03b5 SQL Server instance. To query \u03b1\u03c5\u03c4\u03cc \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03c4\u03c1\u03ad\u03be\u03b5\u03b9 \u03c3\u03b5 \u03bf\u03c0\u03bf\u03b9\u03b1\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c4\u03c1\u03bf\u03c0\u03ae \u03ba\u03b1\u03b8\u03ce\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03c5\u03bd\u03b1\u03bc\u03b9\u03ba\u03cc. \u03a4\u03b9 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf query \u03a5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03cc\u03bc\u03c9\u03c2 \u03ad\u03bd\u03b1 \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u039a\u03b1\u03b8\u03ce\u03c2 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-ti-charaktiristika-echei\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-06T05:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-11T21:48:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance\",\"datePublished\":\"2021-12-06T05:00:00+00:00\",\"dateModified\":\"2025-09-11T21:48:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/\"},\"wordCount\":113,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Databases\",\"Microsoft\",\"RDBMS\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2021-12-06T05:00:00+00:00\",\"dateModified\":\"2025-09-11T21:48:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-vriskoyme-ti-charaktiristika-echei\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr","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.dataplatform.gr\/en\/pos-vriskoyme-ti-charaktiristika-echei\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr","og_description":"\u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03ad\u03bd\u03b1 query \u03c0\u03bf\u03c5 \u03ad\u03c7\u03c9 \u03c6\u03c4\u03b9\u03ac\u03be\u03b5\u03b9 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c4\u03b1 specs \u03c4\u03bf\u03c5 \u03ba\u03ac\u03b8\u03b5 SQL Server instance. To query \u03b1\u03c5\u03c4\u03cc \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03c4\u03c1\u03ad\u03be\u03b5\u03b9 \u03c3\u03b5 \u03bf\u03c0\u03bf\u03b9\u03b1\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c4\u03c1\u03bf\u03c0\u03ae \u03ba\u03b1\u03b8\u03ce\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03c5\u03bd\u03b1\u03bc\u03b9\u03ba\u03cc. \u03a4\u03b9 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf query \u03a5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03cc\u03bc\u03c9\u03c2 \u03ad\u03bd\u03b1 \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u039a\u03b1\u03b8\u03ce\u03c2 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-ti-charaktiristika-echei\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-12-06T05:00:00+00:00","article_modified_time":"2025-09-11T21:48:39+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance","datePublished":"2021-12-06T05:00:00+00:00","dateModified":"2025-09-11T21:48:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/"},"wordCount":113,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Databases","Microsoft","RDBMS","SQL Server"],"articleSection":["Databases","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/","url":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/","name":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2021-12-06T05:00:00+00:00","dateModified":"2025-09-11T21:48:39+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-vriskoyme-ti-charaktiristika-echei\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b9 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf \u03ba\u03ac\u03b8\u03b5 SQL Server instance"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=3057"}],"version-history":[{"count":5,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3057\/revisions"}],"predecessor-version":[{"id":5949,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/3057\/revisions\/5949"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=3057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=3057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=3057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}