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…
Tag: 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…
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to minimize the impact to the business. You are caught in a difficult decision. Do you repair the VM as quickly as possible, but possibly lose traces of what went wrong. In doing so, that loss of…
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting is called network packet size…
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…