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…


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…


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) 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 to verify is that you are using a Enterprise or Developer version…


Generate upgrade script in Reporting Services with WMI

  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 found version is ‘C.0.9.45’. The expected version is ‘147’….