Jaa


jtarquino

Testing Power BI Report Server Setup using Azure DevTestLabs and Visual Studio Team Services (VSTS)

One of the cool things about working in Microsoft is that we have plenty of resources as internal as...

Date: 08/09/2017

Reporting Services Load Testing

A common ask from consultants and architects working with SQL Server Reporting Services is about...

Date: 11/05/2016

Recently our team released the Reporting Services PowerShell Tools as a project to collaborate with...

Date: 10/15/2016

Accessing SQL Server Reporting Services Mobile Reports with the Power BI app from the Internet using Active Directory Application Proxy

In SQL Server 2016 the team introduced Reporting Services mobile reports to SQL Server Reporting...

Date: 07/04/2016

The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM

Recently we were investigating a case reported by one of the Reporting Services customers where he...

Date: 06/19/2016

ARM Templates and SQL Server Reporting Services

  One of the Azure features I have in my list to try is the ARM templates and what better...

Date: 02/28/2016

Debugging Typescript in Visual Studio Code and Chrome

  After a small adventure in a big data team I'm back in the Reporting Services team....

Date: 01/24/2016

Identifying Slow queries in Excel PowerPivot

Technorati Tags: PowerPivot,SQL BI,Excel I had a very slow power pivot report and wanted to identify...

Date: 12/27/2013

Copying PowerPivot tables between Excel workbooks to consolidate Power View Reports

I use multiple Excel PowerPivot models created in different workbooks by multiple people, sometimes...

Date: 11/02/2013

Updating a WCF Azure Service to SSL and Client Certificate authentication

  I created a WCF Service in Azure and started to use it, it started very simple but we added...

Date: 09/03/2013

Console Hosted proxy to read performance counters from Azure into PowerPivot

You can configure Windows Azure Diagnostics to collect the performance counters of your application...

Date: 07/05/2013

Refresh External Data in a Excel Power View workbook hosted on Office 365

One of the cool features of Excel is that you can publish your workbook to different places like...

Date: 04/01/2013

Using Power View in Excel with Reporting Services Reports as data source

  With the addition of Power View in Excel 2013 there are a lot of new things you can do, for...

Date: 01/02/2013

Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint integrated mode

Recently I have been working in disaster recovery for Reporting Services in SharePoint mode and we...

Date: 11/26/2012

How to refresh a Tabular Model

  Power View works with tabular models, the most easy way to work with them is to use the...

Date: 10/24/2012

SQL Server Memory per database

Recently we experienced some issues with not having enough memory in some of our lab machines where...

Date: 09/07/2012

SQL Server Reporting Services 2012 SharePoint integrated mode Endpoints architecture (or how our services talk each other)

Recently I got interested in understanding how our Service works, so I started from at the entry...

Date: 06/13/2012

The SQL Server Reporting Services 2012 Timer Job In SharePoint mode

  I have a box that I use to play around with Subscriptions and Alerting in SQL Server...

Date: 05/07/2012

  Usually the setup logs are not important when you installation is successful , but when...

Date: 03/14/2012

Configuring a Readable Secondary Routing in SQL Server 2012 AlwaysOn

  In my previous job in support I had a lot of questions from customers about High Availability...

Date: 12/12/2011

SQL Server 2012 Reporting Services SharePoint integrated mode

  General Architecture One of the interesting changes we did in Reporting Services was to...

Date: 10/25/2011

Reporting Services Data Driven Subscriptions on SharePoint Integrated Mode

  I have seen in the forums that the people used to the SQL Server Reporting Services (SSRS)...

Date: 06/14/2011

Generate upgrade script in Reporting Services with WMI

  Recently I had to test some of the upgrade scenarios for Reporting Services and in some...

Date: 06/10/2011