Geeks With Blogs
BI cooking with a touch of SQL May 2011 Entries
Reporting Services 2008 R2 Report Parts : the poor man’s version for a template
Ok you have been playing around with SSRS 2008 R2 as did I and while I can’t wait to get my hands on CTP 2 of Denali here is some tips to get your reports a bit more standardized. The concept is called Report Parts. Report Parts are a SSRS 2008 R2 only feature. Basically it allows you to publish elements of a report as a separate objects to the report server. These elements can be any element of a report, as long as there is no custom code in them. So how do you make a report part? Well, that’s simple. ......

Posted On Saturday, May 21, 2011 12:29 AM

SQL Agent Job Queue proxy
Ok, so you have locked your SQL down. No users allowed. But then there is this information worker for whom the IT department made a special SSIS package. And they loaded the package in to the SQL server and created a SQL Agent job for it. Well no problem so far. But now the user wants to be able to start the job when ever he needs to. Hmmm, huge problem. Because you need to have SA equivalent rights. What?? Yes, you read it right. SA equivalent !! Hell no! Ok a sql geek will now say, that's wrong, ......

Posted On Thursday, May 19, 2011 6:32 PM

Copyright © remko | Powered by: GeeksWithBlogs.net