BE SHARING

Christophe Cosme

AWS – RDS – SQL Server Native backups

04.06.2020 by Christophe Cosme

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(…)

Cloud

AWS Automation – Stop a RDS instance

16.03.2020 by Christophe Cosme

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(…)

Database Administration & Monitoring

Power BI Report Server – Kerberos Advanced configuration

16.12.2019 by Christophe Cosme

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(…)

Database Administration & Monitoring

SQL Server – Collecting last backup information in an AlwaysOn environment

12.12.2019 by Christophe Cosme

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(…)

Database Administration & Monitoring

Upgrade your Power BI Report Server

11.12.2019 by Christophe Cosme

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(…)

Business Intelligence

Copy or Migrate a SSISDB environment

11.01.2019 by Christophe Cosme

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(…)

Application integration & Middleware

Power BI Report Server Kerberos Setup

19.11.2018 by Christophe Cosme

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(…)

Business Intelligence

Pass Summit – dbi visit day 4 (2)

09.11.2018 by Christophe Cosme

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(…)

Big Data

Pass summit – day 4

09.11.2018 by Christophe Cosme

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(…)

Big Data

Pass summit – dbi visit day 3

08.11.2018 by Christophe Cosme

The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the(…)