Tags » PowerShell

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. 2,024 more words


PowerShell - Convert To Weblink

During a recent project I was presented with a long text that was supposed to be emailed to administrative staff. The problem with the text is that it contained links to webpages. 366 more words


Building a Chart Using PowerShell and Chart Controls

Reports are one of those things that everyone has done at some point in time using a variety of methods to include, Excel, XML, CSV, HTML, etc.… A lot of times, while the data is one thing to present, there are times when we need to just present a snapshot of information, usually in the form of a chart of some kind. 2,043 more words


The SQL Server Community Collaborative GitHub Organisation is born

My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called dbatools and dbareports

If you are working with SQL Server I highly recommend that you take a look at the vast number of commands available to you at… 247 more words


Converting SQL Agent Job Duration to TimeSpan using PowerShell

When you look in msdb for the SQL Agent Job duration you will find that it is an int.

This is also the same when you look at Get-SQLAgentJobHistory from the sqlserver module. 485 more words


What’s New in PoshRSJob

I’ve been hard at work on PoshRSJob to address some some bugs as well as adding some new features that have been reported in the… 2,260 more words


Today With PowerShell – 3rd September 2016

Today I used PowerShell with the TagLibSharp library to fix, then break, then fix again the ID3 tags on some of my music files.

We buy a lot of compilation CDs here and tend to end up with correctly tagged but unhelpfully named files. 271 more words