Programmatically find MS Shipped Databases

Hello, Have you ever needed to programmatically find what databases in you server are part of Microsoft products? Maybe to use that information in your own piece of code? In my case, I needed that information to exclude Sharepoint and Biztalk databases from the AdaptiveIndexDefrag cycles that are part of the maintenance operations we deploy…


The Kerberos, SharePoint, Reporting Services and Internet Explorer case

Hello everyone,   Last week I had a situation that was tricky to solve and involved Kerberos! At this time you are thinking: “Oh no, here comes big trouble!”. And you are right, it was difficult to understand what was happening but the solution was simple. Let’s get started! The environment setup was the following:…


Take most of Reporting Services Logs with Excel 2013

Hi everybody. It’s been a while since I have posted in this blog about Reporting Services Logs and today we are going to put some of it in practice. The purpose of this post is to use the newest version of Excel 2013 Customer Preview that can be found here and use PowerPivot and Power View…


Three effective tips for Reporting Services management

Have you ever felt the need to check how your reporting services instances are in terms of health? I’m going to give some tips that can start helping you on this subject, but first let’s understand how Reporting Services Logs are structured:   Report Server Execution Log – The report server execution log contains data…


How to integrate SSRS Reports with PerformancePoint Dashboards in SharePoint 2010

Hello all, Probably a few of you have heard about PerformancePoint in Microsoft’s BI stack. PerformancePoint Services is set of tools and services that allow you to create and publish Business Intelligence Dashboards in SharePoint 2010. PerformancePoint tools are the start point to create dashboards to visualize in SharePoint 2010 and understand your costumers’ business…