Microsoft Team

Sql Konferenz 2023 in Hanau, Germany

Introduction It was a very great pleasure to participate to the Sql Server konferenz 2023 in Hanau, Germany, the 12 and 13 September 2023. I went with my colleague Petar, of the same Microsoft Sql Server team by dbi services,(…)

SQL Konferenz 2023 in Hanau – Meet Tame, the data monster

After 2 years, or even 3 years? The organizers could not agree, the SQL Conference took place again in Hanau. 73 speakers have taught us in over 80 sessions with their experience as well as knowledge new. There were incredibly(…)

Lost access to SQL Server. Now what ?

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

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

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

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

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

Programmatically change the data source of a Power BI Report

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

Power BI Report Server Patch Management

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.

Disaster Recovery Solution to Azure SQL Database

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

Prepare Failover Cluster for AG configuration

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

Azure Resource Inventory: Managed instance integration

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