Windows Systems Development


There may come a time when you need to safely truncate data from an active database. To safely perform these steps it’s ideal that you create a backup of your database and perform the following steps on a test basis first. 1. TRUNCATE TABLE dbo.ELMAH_Error 2. Right click your database click Tasks> Shrink Database > and perform a shrink on your database to reclaim the unused disk space. 3. Then run: DBCC CHECKDB to ensure there...

Read More

I wrote this script so you can loop through a CSV which contains a list of IP’s or Hostnames and allows you to verify whether a specific Registry Key and Value exist. Of course this can be modified for further granularity. [message_box type=”info” icon=”yes”] # Filename: checkreg.ps1 # Description: Imports a list of computers from a CSV file and then checks each of the # computersa particular registry...

Read More

Ok so I decided to use my brain to write a cool PowerShell script that allows you to check all nodes within your cluster to ensure that the Temporary ASP.NET Files exists. This script can be easily modified for many other uses such as finding any directory ect. Please let me know your thoughts as I’d be happy to update to provide additional functionality. # Filename: asptempfoldercheck.ps1 # Description: Imports a list of...

Read More