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,126 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,126 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,979 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
510 reads
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
875 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
336 reads
My cheap and dirty PowerShell script for dumping the disk space usage for a Windows machine. It was originally some...
2015-03-24
407 reads
I like to initialize my arrays by strongly typing my variable as an array, and setting it to null. PowerShell...
2015-03-24
629 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
297 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
435 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
250 reads
SQL doesn’t really give us too many tools out of the box to allow...
Did you know that you can change the browser used by SQL Server Management...
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Hi All, Our server team is planning to move secondary data centre from one...
Hello everyone, I am importing from a csv file into a table. Everything works...
Hi all, The app server is running on Linux. SQL server is running on...