Category Archives: PowerShell

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I support.  In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter … Continue reading

Share
Posted in PowerShell, SQL Tuning, SQLServerPedia Syndication | 1 Comment

Cannot create Cluster – the computer X is joined to a cluster

Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The … Continue reading

Share
Posted in PowerShell, SQLServerPedia Syndication, Tibits | 8 Comments

Collect Database File Size with Powershell

I decided to start monitoring the amount of free space in my database files so that I can make sure all my databases are set to auto grow by the right amount and to monitor the amount of free space … Continue reading

Share
Posted in PowerShell, Query Tidbits, SQLServerPedia Syndication | Leave a comment

Get count of folders using Power Shell

More on my recent PowerShell project.  I recon I have taken on the challenge to handle this entire request using Posh.  It started out just moving folders based on the folder name that included the date in format MMDDYY.  Next … Continue reading

Share
Posted in PowerShell | Leave a comment

Starting and Stopping a Remote Service with PowerShell

A recent project I was working on required me to move folders from a staging location to a processing location.  I found that PowerShell was the easiest way to accomplish that.  After getting that part of the project working a … Continue reading

Share
Posted in PowerShell | 1 Comment

My first PowerShell Script to Move Folders

I just had my first encounter with having to write a PowerShell script.  The request seemed pretty harmless when I originally got it.  The request was much like others I had gotten in the past where I needed to check … Continue reading

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