Infrastructure at your Service

All Posts By

Christophe Cosme

Christophe Cosme

SQL Server – Contained Database

By | Database Administration & Monitoring | No Comments

Introduction You may have encounter already case when an application offers the possibility to create and maintain SQL database users and consequently the associated SQL Server instance logins. That’s of course not especially really what a DBA likes, loosing control on the logins that are created on the instance he is responsible of. But sometimes you have to deal with such situation especially when a customer ask you to enable this. Well, then it’s starts…

Read More
Christophe Cosme

SQL Server – PolyBase Services when listening on all IP is disabled

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

Introduction You will find a lot of blogs explaining how to install the PolyBase feature with a SQL Server database instance. You will also learn how to configure it and how to use it in these blogs. But I could not find any solution for one case I was faced to. When you have several SQL Server instances on a server you will either allocate a fix port per instance or a dedicated IP per…

Read More
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