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...
2015-04-27 (first published: 2015-04-14)
8,649 reads
So here we are, week 2 of the #SQLNewBlogger Challenge. This is a follow on to last weeks post Monitoring...
2015-04-27 (first published: 2015-04-14)
8,649 reads
Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...
2015-04-21
1,980 reads
For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...
2015-04-02
526 reads
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
879 reads
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...
2015-03-24
375 reads
My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...
2015-03-24
438 reads
I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...
2015-03-24
657 reads
So I was reading the following blog post by Brent Ozar and I think it finally hit me right between the...
2015-03-24
298 reads
The question was this:
This is just a quick/fast snippet in response to that question, but I can think of a...
2015-03-24
447 reads
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
252 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers