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(…)
Azure, SQL Server SQL-Server 2025: Generate Data Embeddings for Semantic Search 12.08.2025 by Hocine Mechara In this Blog we will continue with our AI journey in SQL-Server 2025 preview. If you didn’t read the first Blog you’ll find it here: dbi Blog In this article, we will explore the concept of data embeddings, a(…)
Azure, Cloud, Development & Performance, SQL Server SQL Server 2025: Where Data Meets Intelligence 05.08.2025 by Hocine Mechara The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase(…)
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(…)
Development & Performance, Docker, SQL Server, Technology Survey SQL Server 2025: Local SQL Server Container – Schema design preview 25.06.2025 by Stéphane Haby After my blogs about “SQL Server 2025: Local SQL Server Container without Docker Command” and “SQL Server 2025: Local SQL Server Container – Schema compare preview”, I continue to play & test it. One new feature in preview(…)
Development & Performance, Docker, SQL Server, Technology Survey SQL Server 2025: Local SQL Server Container – Schema compare preview 24.06.2025 by Stéphane Haby After my blog about “SQL Server 2025: Local SQL Server Container without Docker Command”, I continue to play & test it. One new feature in preview is the “schema compare” in this last extension for Visual Code: I like(…)