Use PowerShell to test if a table exists in SQL

Below is a PowerShell function I wrote as part of a larger script for collating useage statistics from a SaaS environment where it is impractial to know if the database in question will or won’t be one which contains the data needed. By querying the table schema and returning true/false as the output, it allows for its output to be used in an If condition for whether to proceed with running the subsequent queries.

Continue reading “Use PowerShell to test if a table exists in SQL”

Bulk expanding disks after increasing their physical size

About

This script deals with expanding the logical volumes in windows after they have been expanded in the hypervisor. It will work on any windows server which you have remote PowerShell access to, in fact it tests for that before attempting to expand the disks.

It does however make an assumption about disks and volumes. They are hard coded rather than dynamically determined. You’ll need to update it for your server drive lettering standards. Continue reading “Bulk expanding disks after increasing their physical size”

SharePoint 2013 Make the document icon in a document library work

We have a customer who is using Colligo Engage for Outlook, uploading emails to SharePoint Online and tagging them with some additional metadata for other departments to keep track of what is occurring.

All of that is well and good but the name column was just too long to display along with all the other columns in the library view. This is a pretty common problem with long file names and one you can usually solve with users who are uploading traditional files but with this process they didn’t modify the file name Colligo automatically generated.

Continue reading “SharePoint 2013 Make the document icon in a document library work”