DevOps Thread

It's been a month since my last post. Today I am posting a function that can be used to check the status of MS SQL Server databases. At the current moment, I am not sure about the limitations on where this script works like which versions of Windows OS or supported MS SQL Server versions. I have been using the script on my laptop where I have installed Windows 10 OS and SQL Server 2014 Developer Edition. SQL Server Developer edition can be downloaded from here . There are multiple methods to connect to a SQL Server instance from Powershell. I found this very useful article on sqlshack . The script in this post makes use of the SQLPS module. <# . Synopsis Check database status on MS SQL Server instances. . DESCRIPTION Check the database status on one or a list of MS SQL Server instances. . Parameter ServerInstance Provide the server instance to connect to in case of a named instance servername\instancename. . EXAMPLE Get-DBStatus -Serv...

Here is a simple PowerShell function to check the app pool status on remote servers. It make use of Microsoft.Web.Administration Namespace instead of WebAdministration snap-in. Please let me know your feed back. References: https://gallery.technet.microsoft.com/scriptcenter/Powershell-ScriptFunction-2ed89388 https://blogs.msdn.microsoft.com/carlosag/2008/02/10/using-microsoft-web-administration-in-windows-powershell/ <# . SYNOPSIS List the app pools and it' state remotely. . DESCRIPTION Get the app pools and it's status remotely making use of .NET Microsoft.Web.Administration namespace. . PARAMETER ComputerName Provide the name or IP address of a remote computer or a list of computer names separated by a comma. .EXAMAPLE Get-AppPool -Computer comp1,comp2 #> Function Get-AppPool (){ [ CmdletBinding ()] param ( [ parameter ( mandatory = $ True , Position = 1 )] [ string []]$ ComputerName ...

This blog is created as part of my PowerShell learning and getting into the blogging world, so you may see repetitive content. Please bear with me. Here I am posting a simple script that can be used to get RAM memory details from remote windows computers. Please let me know your suggestions on improving the scripts. reference: https://gallery.technet.microsoft.com/scriptcenter/Powershell-Script-to-Get-78687c5e <# . SYNOPSIS Get memory details of a remote server . DESCRIPTION Get the Available physical memory, FreePhysicalMemory, and Percentage of Memory Usage remotely. . PARAMETER ComputerName Accepts a list of computer names or IP addresses . EXAMPLE Get-MemoryUsage -ComputerName computer1 Get-MemoryUsage -ComputerName computer1,computer2 . LINK https://posh-scripting.blogspot.in/2016/10/memory-usage.html #> function Get-MemoryUsage { [ CmdletBinding ()] Param ( # A computer name or list of computer names ...