Infrastructure at your Service

Reporting services Archives - Blog dbi services

David Barbarin

Dealing with SSRS subscription schedules in AlwaysOn environment

By | Database management | 11 Comments

A couple of days ago, I had the opportunity to work with AlwaysOn 2014 infrastructure that included a report server (SSRS) in native and scale-out mode. As you know, dealing with SSRS and availability groups is not an easy task depending on the used features. This is particularly true when scheduling and subscriptions are used by customers. Here’s a brief description of the concerned architecture: 2 SSRS servers in scale-out mode and an availability group…

 
Read More
Matthieu Munch

QlikSense – The easy way to create a QlikView report

By | Entreprise content management | No Comments

Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided to add an additional product in its range. This product should be more accessible and easier to use to create…

 
Read More
Matthieu Munch

Birst: an attractive “all-in-one” Business Intelligence solution

By | Entreprise content management | 2 Comments

The review of the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms has revealed a new challenger that could become one of the leader of this market: Birst – an interesting “all-in-one” BI solution. Birst is an american company based in the Silicon Valley near San Francisco. Its SaaS (Software as a Service) BI solution mixes simplicity and power. Just a little reminder before going forward: a complete Business Intelligence solution has two kind…

 
Read More
Alain Lacour

High availability in the Oracle landscape

By | Hardware & Storage | No Comments

It’s now several weeks I attended some event about high availability (HA). But what is actually high availability? According to our friend Wikipedia, HA is based on 3 main principals: Elimination of Single Point of Failure (SPoF) Reliable crossover (with minimal or no downtime) Detection of failures when they arrive If those principals are met, end users may never realize about a failure. The aim of that blog is not to dive into too much…

 
Read More
Stéphane Savorgnano

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

By | Technology Survey | No Comments

A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the Engine 3 for SSAS 4 for SSRS 4 for SSIS If you want to have…

 
Read More
Stéphane Haby

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

By | Business Intelligence | No Comments

I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks. More information here. Power View is a feature of SQL Server 2012 Reporting Services Add-in…

 
Read More
Stéphane Haby

SQL Server 2012: Cumulative Update 3 (CU3) now available

By | Technology Survey | No Comments

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server 2012, you will have a new build version: 11.00.2332 I will give you a quick…

 
Read More
Arnaud Berbier

Upgrading your Oracle Internet Application Server license

By | Application integration & Middleware | No Comments

With the appearance of WebLogic Server as Oracle application server and the emergence of the Oracle Fusion Middleware suite, some may wonder what will be the support of their Oracle Internet Application server license, e. g. Oracle Forms and Reports services, Business Intelligence Edition, etc. As a consultant, I am often dealing with these kinds of problems and aiming to improve license benefits. In this post, I want to focus on Oracle Internet Application server licenses.

 
Read More