I found a bug in SSMS that you may run into when modifying multi-step jobs. If you delete the last step of a job, when you click OK, you will get a pop up saying the On Success action of the (new) last step will be changed from “Go to the next step” to “Quit […]
I’ve been holding off mentioning anything about this because I still have a hard time believing it’s really happening, but it appears it actually is happening, so… I’m published!! Woo-hoo!! Back in November, 2011 (!), I came across a blog post by Jen McCown soliciting abstracts for chapters of a new book she was thinking […]
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 […]
For the final part of this series on Uptime Monitoring, I’d like to go over my testing methodology. The reporting process is somewhat complicated, so I want to be confident the figures my procedure outputs are correct. Here again, is the sample data I am working with: LogDate UptimeMinutes 2013-08-21 12:00:00 100 2013-08-21 14:15:00 115 […]
This is the final almost final part of my series of articles about creating a process to monitor your SQL Server for downtime. Part 1 can be found here. Part 2 can be found here. Reporting Now that we’ve got a process in place to gather data, we need to create a way to report […]