With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI). I even have a cool YouTube video showing how to connect Power View [...]
Archive for the ‘Reporting Services’ Category
How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
Posted in Analysis Services, Reporting Services, SharePoint on March 25, 2012 | Leave a Comment »
Connecting Power View to Hadoop on Azure–An #awesomesauce way to view Big Data in the Cloud
Posted in BigData, PowerPivot, Reporting Services, tagged Azure, Hadoop, Power View on February 10, 2012 | 3 Comments »
The post Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud provided the step-by-step details on how to connect PowerPivot to your Hadoop on Azure cluster. And while this is really powerful, one of the great features as part of SQL Server 2012 is Power View (formerly known [...]
SQL Server Reporting Services Disaster Recovery Case Study
Posted in Reporting Services, tagged Disaster Recovery on October 23, 2009 | Leave a Comment »
There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS). Based upon customer experience and internal testing, this technical note provides guidance around best practices to design and manage robust end-to-end disaster recovery (DR). This DR method will involve both automatic and manual failover in the form of content switches, [...]
Reporting Services, Report Builder, and ReportViewer Controls
Posted in Reporting Services, tagged Report Builder, ReportViewer, SSRS on April 9, 2009 | Leave a Comment »
I had been asked a number of times what is the difference between Reporting Services, Report Builder, and ReportViewer Controls, so here’s a quick recap: Reporting Services: This is the server-based reporting platform as part of the Microsoft BI stack that allows you to create reporting solutions against multiple data sources. More information can be found at: [...]
Reporting Services, Report Builder, and ReportViewer Controls
Posted in Reporting Services on April 8, 2009 | 97 Comments »
I had been asked a number of times what is the difference between Reporting Services, Report Builder, and ReportViewer Controls, so here’s a quick recap: Reporting Services: This is the server-based reporting platform as part of the Microsoft BI stack that allows you to create reporting solutions against multiple data sources. More information can be found at: [...]
Reporting Services Performance Optimization
Posted in Reporting Services, tagged Performance on January 15, 2009 | Leave a Comment »
The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization. This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services [...]
Reporting Services Performance Optimization
Posted in Reporting Services on January 14, 2009 | 100 Comments »
The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization. This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services [...]
ExecutionLog2 View – Analyzing and Optimizing Reports
Posted in Reporting Services, tagged Performance on January 8, 2009 | Leave a Comment »
An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx Quoted from Robert: Before you can optimize particular reports or your entire system, you need metrics and understand what they tell you. In this posting, I want to focus on how to effectively interpret and utilize the data [...]
ExecutionLog2 View – Analyzing and Optimizing Reports
Posted in Reporting Services on January 7, 2009 | 100 Comments »
An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx Quoted from Robert: Before you can optimize particular reports or your entire system, you need metrics and understand what they tell you. In this posting, I want to focus on how to effectively interpret and utilize the data [...]
Technet Webcast: Building SQL Server Reporting Services 2008 Large-Scale Solutions
Posted in Reporting Services, Uncategorized, tagged Performance, Video on October 24, 2008 | Leave a Comment »
Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions. In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how [...]
Hadoop on Azure
Professional Microsoft PowerPivot for Excel and SharePoint
-
Recent Posts
-
Top Posts
- Update SharePoint 2010 Farm Credentials Tips
- SQL BI at Hadoop Summit = Awesomesauce!
- How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
- SSIS global variables and execute process task
- Troubleshooting #PowerPivot Excel Services connectivity
- Failed to provision the SharePoint Central Administration Web Application
- MDX: Count number of dimension members
- Installing Hadoop on OSX Lion (10.7)
- Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
- Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Categories
Tags
Archives
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- May 2009
- April 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- April 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- December 2006
- November 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- November 2005
- October 2005
- September 2005
- June 2005
@dennylee
- #SQLBI at @HadoopSummit = #Awesomesauce ! wp.me/pHDEa-gH #Hadoop #BigData #SSAS 8 hours ago
- “@HuffingtonPost: Self-help lessons from a two-year-old huff.to/LtzjJi” > yes, I shall do it! 1 day ago
- wow “@mpanzarino: “@asymco: Apple sells its inventory every 5 days. Second fastest only to McDonald's. asym.co/KQnooc” That's nuts.” 2 days ago
- Thank (not evict) our soldiers! “@nytimes: The Appraisal: Afghanistan Veteran Could Lose Home Over Service Dog nyti.ms/KK7Ruc” 2 days ago
- Get it! “@tom_e_white: It's out. #Hadoop: The Definitive Guide, 3rd Edition. oreil.ly/LXTfdT What's new: bit.ly/LXTiWY” 2 days ago
Copyright
