This Article covers the list of Free database and PowerShell tools I come across time to time, this list will keep growing as I discover them, leave comments if you like any one tool better than other.   SQL Server   Database Health – dashboard overview for quick database health checks (http://databasehealth.com) Idera Free tools for SQL server: https://www.idera.com/productssolutions/freetools, below are some of best which I like, they are not totally free but works for […]

While configuring Linked server to oracle database from SQL server, faced following error,   Error: “ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA” (Microsoft SQL Server Error: 7303)     I did following validation checks to ensure things are in place: Tnsnames.ora – validated that SID is present in tnsnames.ora file which is generally located in C:\Oracle\product\11.2.0\client_1\network\admin\ folder Validate syntax of connection string, it should be in below format, ORA123 = (DESCRIPTION = […]

While I tried to use PowerShell to find disk space of a remote server using WMI query, Get-WmiObject -computer <myservername> win32_volume …faced following error/s, ——- Error 1: Get-WmiObject : The RPC server is unavailable Error 2: Get-WmiObject : A security package specific error occurred. (Exception from HRESULT: 0x80070721) —— After some Googling and search found some useful tips to troubleshoot the issue, please find below the consolidated troubleshooting steps, 1) Check that DCOM is enabled […]

I was eagerly searching for a solution to call a VBScript through PowerShell script, after going through several articles and collecting information in bits and pieces from various sources written a very small and useful code, you can use it at your wish, My requirement: Call vbscript along with passing two arguments to it, one is server name and other one is a folder name.   Command: 1. Declare $args to collect arguments (in this […]

Condition: When you are trying to execute any WMI command against a computer, it is resulting in following error, ————- PS C:\Users\testuser\desktop> Get-WmiObject -computer xxxxxxx win32_volume Get-WmiObject : A security package specific error occurred. (Exception from HRESULT: 0x80070721) At line:1 char:14 + Get-WmiObject <<<< -computer 162.53.32.223 win32_volume | Where-object {$_.DriveType -eq 3 -and $_.Label -ne “System Reserved”} + CategoryInfo : InvalidOperation: (:) [Get-WmiObject], COMException + FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand ————- Error: Get-WmiObject: A security package specific […]