Modify SQL Agent Jobs using PowerShell and SMO

So here we are, week 2 of the #SQLNewBlogger Challenge. This is a follow on to last weeks post Monitoring...

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...

Monitoring SQL Agent Jobs when you work for Mr Krabs

For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...

Intro to SQL Server Automation with PowerShell

March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...

Configure SQL Server Agent using SMO

Saw this on twitter and thought I would throw it up on the blog. Easier than responding on twitter.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;

$SQLServerInstance...

Get-DiskSpace

My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...

Gotcha! PowerShell Array Initialization, Difference between PowerShell 2.0 and 4.0

I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...

My Specialty

So I was reading the following blog post by Brent Ozar and I think it finally hit me right between the...

Using New-TimeSpan to convert friendly time

The question was this:

This is just a quick/fast snippet in response to that question, but I can think of a...

Who is cjsommer?

I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...