Category Archives: PowerShell

An overview of Python vs PowerShell for SQL Server Database Administration

Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been ported over to Linux, taking PowerShell along. PowerShell runs really well on Ubuntu, CentOS, RedHat Linux, and even Mac OS X. … Continue reading

Posted in PowerShell, Python, SQL 2017 on Linux | Tagged , , | Leave a comment

PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet

Abstract A common task of any administrator is to manage and maintain the application availability by checking the various services status, accomplish configuring the services and restarting the service on a local/remote system. There are several components are available to accomplish … Continue reading

Posted in PowerShell | Tagged , , , , , , | Leave a comment

PowerShell : Monitoring and Notification – Disk Space Alerts

“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016” Abstract Monitoring disk space utilization of server(s) is the critical and important job for any administrator. Keeping things organized might improve application availability and server availability. This article takes us through … Continue reading

Posted in PowerShell | Tagged , , , , , , , , , , | Leave a comment

PowerShell : CSV – Disk Space Report – Excel

Abstract Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 10 years, I have faced and handled/managed lot of issues … Continue reading

Posted in PowerShell, Uncategorized | Tagged , , , | 1 Comment

PowerShell: Extending Modules – System Parameter measurement

The Microsoft Technet Guru Award  (August 2016) winning article  – Silver PowerShell: Extending Modules – System Parameter measurement PowerShell: Extending Modules – System Parameter measurement Abstract The objective of this post to illustrate the various methods of creating PoSH Modules. To … Continue reading

Posted in PowerShell | Tagged | 2 Comments

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects

Abstract This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with invoking OLE automation procedures and WMI  class libraries using SQL Windows Shell interface. The step by step  details about … Continue reading

Posted in PowerShell, SQL, T-SQL | Tagged , , , , , | 1 Comment

Disk Space GUI Tool – Multi Server(s) – Grid and Email Output

Monitoring server resources is critical and important job of any Administrator. Keeping things organized might improve application availability and server availability. Being a database administrator for 1o years have faced and handled/managed lot of issues with disk space. There are … Continue reading

Posted in PowerShell, Uncategorized | Tagged , , , | Leave a comment

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers. This script outputs sql server configuration, service, start type, Service Account along with startup trace flags. The script will work on SQL … Continue reading

Posted in PowerShell, SQL | Tagged , , | 2 Comments

SQL – MultiServer SQL Inventory – PowerShell

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When … Continue reading

Posted in PowerShell, SQL, Uncategorized | Tagged , , , , , | Leave a comment

PowerShell – Install PowerShell

Recently got a question regarding PowerShell installation hence this post took an existence. How to Install PowerShell various versions http://technet.microsoft.com/en-us/library/hh847837.aspx http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx Can we have more than one version of Powershell? Yes, You can have multiple versions PowerShell. How to switch … Continue reading

Posted in PowerShell | Leave a comment