Browse by Tags

All Tags » SQL Server 2005 (RSS)
29 July 2010
URLs to reports with non-default parameters
You can give somebody a hyperlink to get to a Reporting Services report and that's all they need if there are no parameters or if the default values are what they want. But how do you specify values for parameters? It turns out to be pretty simple but the documentation is a little vague on some of... Read More...
no comments
Filed under: , ,
15 June 2010
Upgrade to 2008 R2
I don't like it, Carruthers. It's just too quiet. Well, I've done the pre-production server, the main live server and the Reporting/BI server with remarkably little trouble. Pre-production and live were rebuilds. I failed live over to our log shipping standby for the duration, which has a... Read More...
no comments
Filed under: , ,
11 June 2010
Upgrading log shipping from 2005 to 2008 or 2008R2
If you're using log shipping you need to be aware of some small print. The general idea is to upgrade the secondary server first and then the primary server because you can continue to log ship from 2005 to 2008R2. But this won't work if you're keeping your secondary databases in STANDBY... Read More...
no comments
Filed under: , , ,
28 May 2010
Upgrading from 2005 to R2
We're about to take the plunge and upgrade our servers from SQL 2005 to SQL 2008 R2. Real world accounts of people upgrading to R2 are a bit hard to find so I thought it might be useful to blog what happens. (I don't count marketing 'case studies' that just say stuff like "The process... Read More...
no comments
Filed under: , ,
18 March 2010
Have you really fixed that problem?
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 calling WinRAR to compress the log backups before... Read More...
no comments
Filed under: , ,
04 March 2010
Log shipping and shrinking transaction logs
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 had unused space that resulted from big, one-off... Read More...
2 comment(s)
Filed under: ,
01 December 2009
Reporting security audit
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 next job. After all, this is crucial stuff. There's... Read More...
1 comment(s)
Filed under: , , ,
25 November 2009
How to process a cube in a SQL Agent job
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 no matter how screwed up the cube processing is... Read More...
5 comment(s)
Filed under: , ,
02 November 2009
Report Manager folder & file security
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 company. We granted the appropriate domain groups... Read More...
no comments
Filed under: , ,
24 September 2009
Backup compression on SQL 2005
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% faster Reporting & BI ready 3 hours earlier than... Read More...
no comments
Filed under: ,