Recently, I had to renew an SSL certificate on an SQL Server Reporting Services (SSRS) server. The task seemed straightforward: replacing an expired certificate with a new one containing the same configuration. However, once the change had been made, HTTPS wasn’t working anywhere — neither via the usual DNS names nor even when accessing the server directly. Only HTTP remained…
Microsoft has announced the end of the SQL Server Reporting Services (SSRS) service. In other words, Microsoft will no longer provide new versions of SSRS. Currently, the latest available version is the 2022 version (https://www.microsoft.com/fr-FR/download/details.aspx?id=104502). However, it is important to note that this service will be supported until January 11, 2033. Moreover, it will still be possible to use SSRS…
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…
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…
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.…
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…
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…
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.…
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…
For this last day (
) of the TechEd 2012, I going to present the new certification cycle for dba who wants to be certified for SQL Server 2012. But before, let’s start with a brief introduction on Enterprise Information Management, also called EIM
In my precedent article, I announce you the first fix for SQL Server 2012.
One week after, the first cumulative update is downloadable on Microsoft website for SQL Server 2012.
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
…
