Using named pipes

We run Analysis Services on the same server as an asynchronous copy of  SQL (mainly for licensing reasons). We have been having problems when processing the cube that it drops the TCP connection to SQL. It was suggested that we use Named Pipes instead of TCP connections. We don't want to turn off TCP completely, so …

Replicating Jobs Between SQL Instances – Schedules

This is part 4 on the series of how to replicate SQL Jobs between instances. Previously I've covered why replicate, setting up and replicating categories. The next item to replicate is Schedules. SQL Agent Schedules are used to tell SQL Agent Jobs when they should run. When you update a schedule, it's not enough just to change the data in the …