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 [...]
So there I am, sitting in my cube, slaving away in front of my screen, trying to figure out which team to take in this week’s NFL Survivor pool, when the phone rings and interrupts me from my task.
“CrazyDBA speaking.”
“There’s something wrong with the database server”
“Okay, which one?”
“I don’t know.”
“You don’t know?”
“No. How many servers [...]
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 [...]
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 box. [...]