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,715 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,715 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,981 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
531 reads
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
880 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
378 reads
My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...
2015-03-24
445 reads
I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...
2015-03-24
661 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
448 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
254 reads
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
Every expert knows you can't make perfect software that never crashes or has bugs....
I wanted to share with you tools from my personal toolbox. If your code...
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers