Skip to content

SQL Server

Microsoft SQL Server in practice: installation, Always On availability groups, backup and restore, performance tuning, security, PowerShell automation, SQL Server on Linux and upgrades.

How to Standardize SQL Server Disks on VMs using Ansible

INTRODUCTION Today, the benefits of automation no longer need much explanation: saving time, reducing human error, and ensuring every environment remains aligned with internal standards. What is less obvious, however, is how using an Ansible Playbook can provide advantages that more traditional scripting approaches — such as large PowerShell scripts — struggle to offer. That is exactly what I want… 

Automate encryption-in-transit for SQL Server

Encryption-in-transit is part of the essential security baseline for SQL Server.Without TLS, TDS packets travel in clear text across the network, making them vulnerable to interception or modification by an attacker attempting to gain access to the system.This is why TLS has become a standard in modern SQL Server architectures. In this article, we will look at how to standardize… 

Common queries on a SQL Server environment for a DBA

This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the server.You can use this query,… 

SQL Server 2025 release

Microsoft has announced the release of SQL Server 2025. The solution can be downloaded using the following link: https://www.microsoft.com/en-us/sql-server/ Among the new features available, we have: We also note the release of SQL Server Management Studio 22. References : https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2025?view=sql-server-ver17https://techcommunity.microsoft.com/blog/sqlserver/sql-server-2025-is-now-generally-available/4470570https://learn.microsoft.com/en-us/ssms/release-notes-22 Thank you. Amine Haloui

SQL Server’s LinkedIn Posts catch-up!

You may not have followed all my posts this summer about what we are doing with Microsoft SQL Server technology and the BI stack like Power BI and Azure Data Fabric. So, I thought I’d write a little catch-up blog post, to help you to find all LinkedIn Posts! First, a bit of humour with this image of SQL Server… 

SQL Server: Do you know how to use SERVERPROPERTY()  function in a useful way?

The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it’s good to come back to basis… How to begin? Read the documentation of course here but you will see a lot of informations… After reading the documentation, how to have the first useful information? The first information will be about…