Infrastructure at your Service

All Posts By

Christophe Cosme

Christophe Cosme

Power BI Report Server – URL reservation Warning – Delegation blocked

By | Business Intelligence | No Comments

Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working fine. Where as on the development server the delegation was not working at all. We had as well a comparable behavior on the production environment, but only sporadically. The same data source worked fine for…

Read More
Christophe Cosme

AWS – RDS – SQL Server Native backups

By | AWS, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance. This post explains how you can enable the native database backup on RDS , as you are used to with an on-premises SQL Server instance. To summarize we will create a…

Read More
Christophe Cosme

AWS Automation – Stop a RDS instance

By | Cloud, Database Administration & Monitoring, Database management | No Comments

Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered. In this article I will share the solution I implemented to achieve my goal. I assume you have already created a RDS…

Read More
Christophe Cosme

Power BI Report Server – Kerberos Advanced configuration

By | Database Administration & Monitoring | No Comments

Introduction Following the basic configuration explained in a previous blog (Link), I describe here how to make more advanced configurations in some specific cases but often met by customers. It is only complementing what has being described in the previous blog in some specific situations needing additional or alternative configurations Configuration using HTTPS protocol with DNS alias If you are requested to secure the access to you Power BI Report Server, the solution is to…

Read More
Christophe Cosme

SQL Server – Collecting last backup information in an AlwaysOn environment

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with more than 30 filegroups and around 600 database data files each and moreover synchronized in an AlwayOn availability group, it is not the same story and you can easily imagine that working with standard backup…

Read More
Christophe Cosme

Upgrade your Power BI Report Server

By | Database Administration & Monitoring | 2 Comments

Introduction Even if upgrading your Power BI Report Server is straight forward, I have been asked many times where to find the installation files and how to run it that I thought a blog is worth it. Before you start Before upgrading your Power BI Report Server it is recommended to perform some backup steps. Back up the encryption keys Back up the report server databases Back up the configuration files (in the default installation…

Read More
Christophe Cosme

Copy or Migrate a SSISDB environment

By | Business Intelligence, Database Administration & Monitoring, Database management, SQL Server | 2 Comments

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate your SQL Server instances, but some are missing that can be very useful. You have the possibility to move an SSISDB environment but this is only possible in another folder of your SSIS catalog. But how if you will to duplicate your environment or move…

Read More
Christophe Cosme

Power BI Report Server Kerberos Setup

By | Application integration & Middleware, Business Intelligence, SQL Server | One Comment

In the case you have the following configuration and requirements Your Power BI, paginated mobile KPI reports are published on your on premise Power BI Report Server (Named i.e. SRV-PBIRS), their data sources is an Analysis Services located on another server (Named i.e. SRV-SSASTAB\INST01, INST01 being the named instance) and you want to track/monitor who is accessing the data on Analysis Services or you have row level security constraints. In such case, if you have…

Read More
Christophe Cosme

Pass Summit – dbi visit day 4 (2)

By | Business Intelligence, Entreprise content management | No Comments

Power BI 5 top custom visuals The development of Power BI itself is fast. But, the means to represent data is too. I mean there are constantly new Power BI custom visuals developed by the community and Microsoft. You can develop your own custom visuals and publish them on the marketplace for your organization or the whole community. Tips : check if the visuals are certified, meaning they have been tested on the different Power…

Read More
Christophe Cosme

Pass summit – day 4

By | Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Development & Performance | No Comments

Optimizing Multi-Billion Row Tables in Tabular in 2018   I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is stored and organized in a Tabular model. It is of course using the xVelocity in-memory capabilities with the Vertipac column storage layout engine. It organizes the data, compressing  it by column,  in combination with a dictionary…

Read More