{"id":8560,"date":"2016-07-14T05:54:16","date_gmt":"2016-07-14T03:54:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/"},"modified":"2016-07-14T05:54:16","modified_gmt":"2016-07-14T03:54:16","slug":"sql-server-2016-new-sql-powershell-cmdlets-for-errorlog","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/","title":{"rendered":"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog"},"content":{"rendered":"<p>With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable <a title=\"SQL Server Management Studio download\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\" target=\"_blank\">here<\/a>, was introduced new CMDLETs for Always Encrypted, SQL Agent and the\u00a0 ErrorLog.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9757 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01.png\" alt=\"SSMS_update01\" width=\"651\" height=\"446\" \/><\/a><\/p>\n<p>In this article, I will present you the 2 new CMDLETs for the Error Logs:<\/p>\n<ul>\n<li>Get-SqlErrorLog: Retrieves the SQL Server Logs.<\/li>\n<li>Set-SqlErrorLog: Sets or resets the maximum number of error log files before recycling.<\/li>\n<\/ul>\n<p>My first step is to search all commands with \u201cSql\u201d:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-Command | Select Name |Where-Object {$_.Name -like \"*Sql\"*}<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9765 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_01.png\" alt=\"PowerShell_ErrorLog_01\" width=\"676\" height=\"601\" \/><\/a><\/p>\n<p>As you can see, I have a lot of commands. I filter with SqlErrorLog and have the detail of both commands:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-Command | Where-Object {$_.Name -like \"*SqlErrorLog*\"} | Format-List *<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9761 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_02.png\" alt=\"PowerShell_ErrorLog_02\" width=\"674\" height=\"727\" \/><\/a><\/p>\n<p>To have the detail per command, I use these commands:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-Command | Where-Object {$_.Name -eq \"Get-SqlErrorLog\"} | Format-List *\nGet-Command | Where-Object {$_.Name -eq \"Set-SqlErrorLog\"} | Format-List *<\/pre>\n<p>&nbsp;<\/p>\n<h3>CMDLET Get-SqlErrorLog<\/h3>\n<p>For Example, a simple query to retrieve all backup lines:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-SqlErrorLog | Where-Object { $_.text -like \"*BACKUP*\"} | Out-GridView<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9764 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_03.png\" alt=\"PowerShell_ErrorLog_03\" width=\"1009\" height=\"467\" \/> You can do the same for the failed login:<\/a><\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-SqlErrorLog | Where-Object { $_.text -like \"*Failed*\"} | Out-GridView<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9760 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_04.png\" alt=\"PowerShell_ErrorLog_04\" width=\"960\" height=\"458\" \/><\/a><\/p>\n<p>Or directly find all errors between 2 dates with \u2013Before and \u2013After parameters:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Get-SqlErrorLog -Before \"2016\/06\/30\" -After \"2016\/06\/28\" | Where-Object { $_.text -like \"*Error:*\"} | Out-GridView<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9763 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_05.png\" alt=\"PowerShell_ErrorLog_05\" width=\"830\" height=\"297\" \/><\/a> &gt;<\/p>\n<h3>CMDLET Set-SqlErrorLog<\/h3>\n<p>It is very easy to configure the number of errorlog files with this command:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">Set-SqlErrorLog -MaxLogCount [6-99]<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9759 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_06.png\" alt=\"PowerShell_ErrorLog_06\" width=\"703\" height=\"555\" \/><\/a><\/p>\n<p>After the command:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9762 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_07.png\" alt=\"PowerShell_ErrorLog_07\" width=\"712\" height=\"287\" \/><\/a><\/p>\n<p>For the fun, I try to enter a value equal to 1 and a value equal to 100 to see if an error message appears:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-9758 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerShell_ErrorLog_08.png\" alt=\"PowerShell_ErrorLog_08\" width=\"677\" height=\"449\" \/><\/a><\/p>\n<p>It is very nice to have these 2 news CMDLETs in SQL PowerShell \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the\u00a0 ErrorLog. In this article, I will present you the 2 new CMDLETs for the Error Logs: Get-SqlErrorLog: Retrieves the SQL Server Logs. Set-SqlErrorLog: Sets or resets the maximum number of error [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":8570,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[49,272,566,880],"type_dbi":[],"class_list":["post-8560","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-microsoft","tag-powershell","tag-sql-server-2016","tag-sql-server-management-studio"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog - dbi Blog<\/title>\n<meta name=\"description\" content=\"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog\" \/>\n<meta property=\"og:description\" content=\"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-14T03:54:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"651\" \/>\n\t<meta property=\"og:image:height\" content=\"446\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog\",\"datePublished\":\"2016-07-14T03:54:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\"},\"wordCount\":196,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png\",\"keywords\":[\"Microsoft\",\"PowerShell\",\"SQL Server 2016\",\"sql server management studio\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\",\"name\":\"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png\",\"datePublished\":\"2016-07-14T03:54:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png\",\"width\":651,\"height\":446},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog\"}]},{\"@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 2016: New SQL PowerShell CMDLETs for ErrorLog - dbi Blog","description":"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog","og_description":"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/","og_site_name":"dbi Blog","article_published_time":"2016-07-14T03:54:16+00:00","og_image":[{"width":651,"height":446,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog","datePublished":"2016-07-14T03:54:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/"},"wordCount":196,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png","keywords":["Microsoft","PowerShell","SQL Server 2016","sql server management studio"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/","name":"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png","datePublished":"2016-07-14T03:54:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"I will present you the 2 new CMDLETs for the Error Logs: Set-SqlErrorLog and Get-SqlErrorLog","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SSMS_update01-1.png","width":651,"height":446},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-sql-powershell-cmdlets-for-errorlog\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog"}]},{"@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\/8560","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=8560"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8560\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8570"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8560"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}