BE SHARING

Microsoft Team

Lost access to SQL Server. Now what ?

15.03.2023 by Microsoft Team

In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account by(…)

Cloud

Maintenance Azure SQL DBs in Elastic Pool (Private Endpoint) – example based on index fragmentation – password less – azure managed identity

08.03.2023 by Microsoft Team

How do you check and rebuild your indexes for Azure SQL DBs in Elastic Pool? That question is getting even more interesting if you have only Private Endpoint enabled to connect to the MSSQL DB. Lets get started! Requirements Azure(…)

Cloud

Estimate the Downtime for an Offline MS SQL Migration: On-Premise to Azure SQL Database

28.02.2023 by Microsoft Team

As you want to migrate your database workload to the Azure Cloud, you must test different aspects of the migration. An important factor for an offline migration is to estimate the duration of the migration process, so the service owner(…)

Business Intelligence

Programmatically change the data source of a Power BI Report

28.02.2023 by Microsoft Team

Executive Summary In this post, I want to demonstrate how to programmatically change the data source of a Power BI report. This can be useful when you develop and test the report then want to publish the report in Test,(…)

Business Intelligence

Power BI Report Server Patch Management

28.02.2023 by Microsoft Team

Executive Summary As service manager in your company, you want to have your MS SQL component patch with the latest version. In a regular basis you need to know the current version of the MS SQL components on your server.

Cloud

Disaster Recovery Solution to Azure SQL Database

27.02.2023 by Microsoft Team

Executive Summary As preparation for migrating his MS SQL workload to the cloud, a customer ask for a disaster recovery solution from an On-Premise MS SQL Instance to an Azure Cloud. The starting point for the disaster recovery will be(…)

SQL Server

Prepare Failover Cluster for AG configuration

01.12.2022 by Microsoft Team

In this blog I will show you some important powershell commands to prepare a Failover Cluster for AG configuration. Please keep in mind, this is a test environment and I will not talk about firewall rules. Our objective is to(…)

Cloud

Azure Resource Inventory: Managed instance integration

25.10.2022 by Microsoft Team

Intro Let me present you in this Blog post a useful tool to asset your Azure environment and in a second step show you how to add Azure SQL managed instance in the assessment report. ARI presentation(…)

Database Administration & Monitoring

How SQL Server MVCC compares to Oracle and PostgreSQL

09.02.2020 by Microsoft Team

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

Cloud

Provisioning a AKS cluster and KubeInvaders with Terraform

27.10.2019 by Microsoft Team

Provisioning a K8s infrastructure may be performed in different ways. Terraform has a connector called the Kubernetes provider but it doesn’t allow building and deploying a Kubernetes cluster. The cluster must be up and running before using the provider.