Browse by Tags
All Tags »
SQL Server 2005 (
RSS)
The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves...
I just solved a problem that had me worried for a bit. I'm log shipping from three primary servers to a single secondary server, and the transaction log disk on the secondary server was getting very full. I established that several primary databases...
Today I set out to produce a list of who has access to each report so I could get this audited by the business management. I didn't think it would take long. Download a couple of scripts, evaluate them, pick a good one, execute it, and on with the...
It can be done but it's not well documented and it's complicated by the fact that you can't easily get the result of the process. Unless you actively check and manually raise an error if there's been a problem, the job will report sucess...
Just found the answer to something that has been irritating me slightly for ages: how to give a user access to a report without giving them access to all the other reports in the folder. We have folders that are based on the roles people perform in the...
Last night, after a lot of preparation, I finally flicked the switch on the backup compression solution I've been implementing. The results were dramatic but in a good way: backup jobs 60% faster 50% disk space saving Reporting & BI build 30%...
In my last post I showed how to reliably get your SQL Agent jobs to only bother you if they fail. But how can you be confident that they are in fact running? Well, what I did is I set up a report in Reporting Services that reads the job history tables...
How to force a SQL Agent job to keep going after an error, yet still notify you that something went wrong....