SQL Server

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

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

A generic jdbc tester (part III)

A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Firebird, SQL Server, HSQLDB, MongoDB, Excel, conclusion.

SQL Server: Heap page deallocation and IndexOptimize

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.

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

Installing Azure AZ Module on Windows

Since Azure (or AzureRM) module is marked as deprecated some years ago, AZ module is the official replacement to manage Azure resources with PowerShell. This module is running with at least PowerShell 7.0.6 LTS (Long Term Support) or(…)

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

Data Platform Virtual Summit 2022 –  Day 4 – Focus on Azure SQL Managed Instance

Today the Data Platform Virtual Summit begin at 09:30 am with the keynote: Creating a Data Culture… My schedule for the day: D4B1 – SPHINX – Configure SQL Server for efficient troubleshooting – Intermediate – Christophe LaporteD4B2 – HYDRA –(…)

Data Platform Virtual Summit 2022 –  Day 3

Today the Data Platform Virtual Summit begin at 06:00 am for us…It’s in our time offset, this time better to wake up! 😉 My schedule for the day: D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay(…)