If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my presentations, you know I hate doing things manually. Over my career, I have found that one of the biggest enemies of automation is being able to get someone else to do it manually. If you…
Category: PowerShell
T-SQLTuesday #94: Using Invoke-SQLCmd to run SQL Jobs Remotely
It’s time for another T-SQLTuesday blog party, and it’s being hosted this month by Rob Sewell (blog|@sqldbawithbeard). So export-ideas from his announcement post or create a new-idea of your own, and then join in the party. For my contribution to this event, I want to talk about how I prefer to use a remote job…
Automated Backup Tuning
Tuning your backups is a wonderful thing. You could easily reduce the time it takes to backup your databases by 50% of more just by changing a few settings, and yet so few people do it. I asked myself the question why and came up with two answers. People do not know how to tune…
Passing SQL Data To Command Line Processes Within SQL Jobs
Wow, that title is a bit of a mouthful, let me give you a scenario to help understand what the business problem was that I ran in to today. We have a production database running on SQL 2008 which contains a CLR procedure that accepts a reportID value, queries some data and writes out to…
Changing SQL Agent Job Subsystem Queue Lengths
In the event you are running a lot of jobs on your SQL Server, or you happen to have a great number of jobs that kick off close to each other and use the same subsystem (i.e. PowerShell) then you might receive a warning in the SQL Agent Error Log stating that the job step…