Powershell script function for disk free

Question: I'm currently building a script to return all SQL Servers in the environment . As part of the recordset I need to return the aggregated free space for the drives on the server. So for example , if these were the drive free space details for a specific servers C:\ 52 GB free E:\ 7 GB free F:\ 9 GB free G:\ 5 GB free than the figure to return is 73 GB , I'd like this to be a Powershell function , so then I can reference it for any server, therefore the input parameter should be servername... Read more →

Get Server Total Physical Memory with Powershell

Question: The server team have added a bunch og memory to a server . How can I get the Total Physical Memory of a server using Powershell? The server is a remote server. Answer; A common method to extract the total physical memory of server is using : Get-WMIObject and TotalPhysicalMemory According to the documentation : "The Get-WmiObject cmdlet gets instances of Windows Management Instrumentation (WMI) classes or information about the available WMI classes. " There is an option to query a remote compueter by specifying a name on the -Computername switch. An example of the Powershell code. The result... Read more →

How to unzip in Powershell

Question: I have a zip file , which I normally win-zip or unzip . I'd like to unzip an archive file as part of a Powershell script Answer: You can use the Powershell cmdlet - Expand-Archive . I've also included some added bits around the ps cmdlet Expand-Archive , which will assist in managing access & file clean up . # Unblock if there's a block – common problem Unblock-File test.zip -ErrorAction SilentlyContinue #the actual expand process Expand-Archive -Path test.zip -DestinationPath e:\exsample\sql_server\modules -Force #to remove your zip file Remove-Item -Path test.zip Read more on Powershell scripts Powershell Script Library for... Read more →

How to unzip in Powershell

Question: I have a zip file , which I normally win-zip or unzip . I'd like to unzip an archive file as part of a Powershell script Answer: You can use the Powershell cmdlet - Expand-Archive . I've also included some added bits around the ps cmdlet Expand-Archive , which will assist in managing access & file clean up . # Unblock if there's a block – common problem Unblock-File test.zip -ErrorAction SilentlyContinue #the actual expand process Expand-Archive -Path test.zip -DestinationPath e:\exsample\sql_server\modules -Force #to remove your zip file Remove-Item -Path test.zip Read more on Powershell scripts Powershell Script Library for... Read more →

How to capture errors from SQLCMD

Question: I'm executing code using SQLCMD from a batch file . The code points to a sql file and there is also an output file. SQLCMD -E -S MYSERVER\INST1 -i "setup_job_entry.sql" -o "setup_job_entry.log" But I noticed that if the actual SQLCMD returns an error , for example , if I'm connecting to an server which doesn't exist this error message will appear in the output file - but there will not be an ERROR number , which would allow me to trap and return an appropriate message Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SQL Server Network... Read more →