SQL Server

SQLBits 2023 -Day 1-A day with SQL Managed Instance

Tuesday 14.03.23 was the first day of SQLBits. This day was dedicated to the workshop, and I chose to follow “A Day with SQL Managed Instance”.During this day, we talked about provisioning, connection and configuration, security, but also data(…)

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

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

Move SQL Server database files to different folders with PowerShell

In my previous post, I explained how to move SQL Server databases files programmatically by leveraging the high availability of an Availability Group (AG).But when you can afford to have a database unavailable for a short time, and(…)

Move secondary database files in SQL Server AG with PowerShell

For some circumstances, you may want to move data and log files for a database to a different location.Usually, this operation has to be made offline. But with an Availability Group (AG) environment, it is possible to choose an(…)

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

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

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

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