Database Administration & Monitoring, Database management From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 1 – Basics 02.10.2025 by Daniel Westermann Migrating from one database system to another is not an easy task. It might be easy if you only need to migrate the data, but as soon as you have business logic in the database this can become a lot(…)
Database Administration & Monitoring, Database management, MS Teams, SQL Server How to patch SQL Server instances with Qualys Patch Management 30.09.2025 by Stéphane Savorgnano By one of our Customers, I have to use Qualys to patch their production SQL Server instances. And to be more precise the Qualys Patch Management application which provides a solution to manage vulnerabilities and deploy patches to secure(…)
Database Administration & Monitoring, Database management Unit Testing PostgreSQL with pgTAP 29.08.2025 by Joan Frey Introduction Unit testing is a fundamental practice in software development, ensuring that individual components function correctly. When working with PostgreSQL, testing database logic—such as functions, triggers, and constraints—is crucial for maintaining data integrity and reliability. One powerful tool for this(…)
Database management, SQL Server SQL-Server 2025: Vector Indexes & Semantic Search Performance 20.08.2025 by Hocine Mechara When performing search operations on large datasets, performance is a key consideration for ensuring that an application remains efficient and user-friendly. This consideration equally applies when working with embedded data. That’s why in this blog post we’ll explore the different(…)
Database Administration & Monitoring, Database management, Development & Performance, SQL Server Customer case study – Partition switching and transactional replication 31.07.2025 by Amine Haloui The client’s environment includes two SQL Server instances (I1 and I2). One of the databases, D1 (on I1), is replicated to I2 via transactional replication. Additionally, the tables in this database are partitioned. The largest table (which is the one(…)
Database management, Development & Performance, SQL Server SQL Server 2025 – Optimized Locking 22.07.2025 by Roger Schönmann Within the past few days I was investigating one of the new features of SQL Server 2025: Optimized Locking. I was curious about the capabilities, the behaviour and as well the limits of the feature. Optimized Locking is based on(…)
Database management, Development & Performance, SQL Server SQL Server 2025 – OPTIMIZED_SP_EXECUTESQL 21.07.2025 by Roger Schönmann Within the past few days I was investigating another new feature of SQL Server 2025: OPTIMIZED_SP_EXECUTESQL. I was curious about the capabilities and the behaviour. OPTIMIZED_SP_EXECUTESQL is a database scoped configuration which allows us to get rid of the overhead(…)
Database Administration & Monitoring, Database management, SQL Server Contained Availability Group and login failed 04.07.2025 by Stéphane Savorgnano A contained availability group is a special availability group which manages its owns logins, users, permissions, jobs… with a dedicated master and msdb system databases, more information here.At a customer place we found some unexpected “login failed” for the(…)
Database Administration & Monitoring, Database management, SQL Server, Technology Survey SQL Server: New SQL Server Management Studio (SSMS) landing page 01.07.2025 by Stéphane Haby After the new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages, you have a new landing page for SQL Server Management Studio (SSMS) : https://learn.microsoft.com/en-us/ssms You will see 6(…)
Database Administration & Monitoring, Database management, Docker, SQL Server, Technology Survey SQL Server 2025: Local SQL Server Container without Docker Command 23.06.2025 by Stéphane Haby The last version of” MSSQL extension for Visual Studio Code” has in Preview “the Local SqlServer Containers” based on SQL Server 2025 with the following keys: Create and manage SQL Server containers locally without Docker commands Use SQL Server 2025(…)