Browse by Tags

• 2007
• 2008
• bi
• books online
• business intelligence
• databases
• elearning
• enhancement
• information
• integration services
• management
• new
• office
• performance
• performancepoint
• permissions
• reportserver
• reportservertempdb
• resources
• rsexecrole
• samples
• security
• sql server
• sqlagent
• ssis
• ssrs
• tools
• training
• troubleshooting
• webcast

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
27 May 08 01:48 AM | SQL Master | 2 Comments   

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their Read More...

Filed under: sql server, databases, Reporting Services, security, sqlagent, permissions, reportserver, reportservertempdb, rsexecrole

SQL Server Reporting Services: Resources and information - all in one place
13 May 08 01:30 AM | SQL Master | 2 Comments   

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend to Read More...

Filed under: sql server, performance, Reporting Services, business intelligence, information, troubleshooting, books online, resources

SQL Server BI and Performance Point Server 2007 - good match
13 March 08 03:10 AM | SQL Master | 2 Comments   

Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse Read More...

Filed under: tools, training, 2007, sql server, bi, webcast, Reporting Services, performancepoint, management, business intelligence, elearning, office

SQL Server 2008 BI enahncements - what you want is what you get!
25 February 08 01:49 PM | SQL Master | 2 Comments   

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped Read More...

Filed under: sql server, bi, performance, ssis, ssrs, Reporting Services, samples, business intelligence, enhancement, new, 2008, integration services

Reporting Services - Getting the Matrix to Display Two Subtotals for the Same Group
21 July 06 04:55 PM | Elizabeth Vitt | 0 Comments   

This week I am switching gears to talk about a cool design technique for the Reporting Services matrix. At least it is cool to me J and hopefully it will be helpful to you. In some design scenarios, you may require two “subtotals” for the same group of Read More...

Filed under: Reporting Services