Reporting Services Load Testing

  A common ask from consultants and architects working with SQL Server Reporting Services is about capacity planning and how to validate that the environment proposed will meet the estimated workload, it is a simple question with a very complex answer because there are plenty of variables in an enterprise SQL Server Reporting Services deployment….

1

PowerShell module with continuous integration, static analysis and automatic publish to gallery

  Recently our team released the Reporting Services PowerShell Tools as a project to collaborate with the community, we had a lot more feedback and participation that we ever thought so we decided to push it a little further and publish it to the PowerShell Gallery. We aren’t by any means PowerShell experts and when…

0

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 Services optimized for mobile devices and connected to on-premises data, with an assortment of data visualizations. The mobile reports can be consumed using any mobile device (IPhone, IPad, Android, Windows 10) in the Power BI mobile app while…

4

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 example than configuring SQL Server Reporting Services in a two machines configuration, one machine with Reporting Services and the second machine with SQL Server for the Reporting Services databases. (Disclaimer: I work in the SQL…

1

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. Everything is new and at the same times some things never change, but I found very quickly that SSRS is building the new portal with recent web technologies such as Angular and Typescript, check out the announcement here…

9

Identifying Slow queries in Excel PowerPivot

Technorati Tags: PowerPivot,SQL BI,Excel I had a very slow power pivot report and wanted to identify which query was taking the time so I enabled the tracing The trace is generated by default in your desktop, the trace is a SQL Profiler trace so you will need to use SQL Profiler to open it. When…

0

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 new features that need to be protected, so I started the journey of taking my simple WCF Service and configure it to use SSL and client authentication, one of the requirements was minimal downtime, so…

2

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 and store it in the storage account, those counter will be available in the WADPerformanceCounters Table, there are third party tools and some blogs about how to consume this data but I wanted few features.   As fast as possible…

0

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 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 it without connection to your corporate network. Although there…

4

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 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: Check the report definition, view…

3

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 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 SQL Server Reporting Services in SharePoint Integrated Mode. I hope this document…

2

How to refresh a Tabular Model

  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 the data refresh using the SharePoint UI,…

7

SQL Server Memory per database

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 and we identified that SQL Server engine was the component using more memory…

1

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 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 this pages to render reports or to accomplish management tasks like publishing…

4

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 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 happened, usually you can troubleshoot this kind of…

2

Navigating the Setup Logs when you install SQL Server 2012 Reporting Services

  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. The SQL Server setup logs for SQL Server 2012 are located…

1

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 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 about it and how to use the Readable Secondary. My…

5

SQL Server 2012 Reporting Services SharePoint integrated mode

  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 experience and integrated scale out capabilities to mention some of them. First at all I had…

11