SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of […]
I wrote a while ago about setting up alerts for database mirroring events – when mirroring is suspended and resumed. It’s been a month or so since I’ve implemented those alerts and I’ve discovered I need to make some minor adjustments to my maintenance plans to accommodate them. My standard maintenance plans are set to […]
I like to keep my Windows Event Logs clean. To me, the event log should be a place to go to find errors. In fact, the only time I look at the event log is when I’m seeing errors with the system. So when programs write informational messages to the event log, I try to […]
I usually don’t make entries here that consist of just links to other things, but I have to make an exception in this case. I just came across Josef Richberg’s article about using SSIS and parallelism and I am thoroughly impressed! He took a job that was taking 40 hours to run and cut it […]