jtarquino

One of the cool features of Excel is that you can publish your workbook to different places like SharePoint or even Office 365 , the nice thing about publishing in Office 365 is that usually you can share it with people across the world and accessing...

  With the addition of Power View in Excel 2013 there are a lot of new things you can do, for instance I have a report with some data which I want to do data exploration. The right data is already  published in a report so I have two options...

Recently I have been working in disaster recovery for Reporting Services in SharePoint mode and we were working in a document with the details, today the document has been published and you can read get it from here Planning Disaster Recovery for Microsoft...

  Power View works with tabular models, the most easy way to work with them is to use the PowerPivot gallery in SharePoint and publish a Excel File with a PowerPivot model to create a Power View report on top of it, from there you can easily setup...

Recently we experienced some issues with not having enough memory in some of our lab machines where we were running tests in a Single Box. This configuration has many components on it like SQL Server engine, Analysis Services, Reporting Services and SharePoint...

Recently I got interested in understanding how our Service works, so I started from at the entry point to Reporting Services. As a final user you usually interact with Reporting Services through Web Pages that are hosted in SharePoint 2010, you use...

  I have a box that I use to play around with Subscriptions and Alerting in SQL Server Reporting Services 2012 in SharePoint mode, recently the alert that I’m use to get at mornings didn’t show up for some days , so I started to investigate what...

  Usually the setup logs are not important when you installation is successful , but when something goes wrong and the setup fails is important to know where you can get more information beside the error message that is shown in the user interface...

  In my previous job in support I had a lot of questions from customers about High Availability and load balancing in SQL Server Databases, so when I saw the announcement of SQL Server 2012 AlwaysOn , it caught my attention and I decided to learn...

  General Architecture One of the interesting changes we did in Reporting Services was to change our SharePoint mode from a Windows Service to become a SharePoint Shared Service, there are many benefits on that one like integrated administration...

  I have seen in the forums that the people used to the SQL Server Reporting Services (SSRS) Native mode are having issues to find the Data Driven Subscriptions options when they are using the SharePoint Integrated Mode. The first thing you need...

  Recently I had to test some of the upgrade scenarios for Reporting Services and in some scenarios I hit the infamous error message "The version of the report server database is either in a format that is not valid, or it cannot be read. The...