I received an email from a colleague the other day. He was having some issues with a job running in SQL Agent. Essentially, the code inside one of the steps would raise an error, and the step would immediately end. Now, we all know that there are limited options for any job step (Quit Reporting … Read more
For the past few months I have been trying to outline the most effective way for our team to recover a server in the event of a disaster. Say, for example, if you have a production box on the SAN and someone accidentally reallocates your server storage, wiping away everything and forcing you to rebuild … Read more
Linked servers are driving me crazy. Well, not them exactly. Rather, how they are used, or misused, by people. I am not certain why, but people tend to think that you can run a query that pulls from a linked server and the results should be similar as if the data was local to the … Read more
So, PASS 2007 is over. It has been done for the past week now, and I have been piecing together my thoughts since then. I started thinking about PASS in general, then I started to focus on specific items such as “what do I get for my membership fee”? In the past week I have … Read more
Today is the last day for the conference, and I am quite tired. To make things worse, my flight out of here is at 6:30AM tomorrow morning. Ick. I checked on some options to leave earlier, but none were viable. So, it looks like I will head to dinner with some friends, stay up most … Read more
Today was another good day, full of good content as well as lots of networking opportunities. After the keynote session, I headed over to a talk about execution plan cache analysis. There was lots of good information presented regarding the new dynamic management views in SS2K5. Some cool tricks were shown as well, including how … Read more
