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(…)
Azure, Big Data, Business Intelligence, Cloud, Database Administration & Monitoring Exploring the Future of Data at SQLBits 2025 in London 21.06.2025 by Hocine Mechara I’m looking back on three amazing days of interesting technical insights from the SQLBits event 2025 in London. It’s actually my first time having the pleasure of attending one of Europe’s biggest data platform events and I can sincerely say,(…)
Database Administration & Monitoring, Database management, SQL Server, Technology Survey SQL Server 2025: What news on the instance configuration 20.06.2025 by Stéphane Haby Like every time with a new version of SQL Server, it’s good to see what the new configurations possibilities are for us to manage the instance. To do this, I will compare SQL 2022 and SQL 2025 using the system(…)