Browse by Tags

Tagged Content List
  • Blog Post: Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular PowerShell) and that you change the HAL9000...
  • Blog Post: Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure...
  • Blog Post: Master Agent Servers

    SQL Server has the ability to create a central location where you can push out certain SQL Agent Jobs to run on other servers. This feature is called a MSX/TSX arrangement, and it's been around for a while. In SQL Server 2005, you didn't want to use SQL Server 2000 systems as targets, because the SQL...
Page 1 of 1 (3 items)