Mladen Prajdic

In this session, we'll build a complete local RAG pipeline using .NET and SQL Server. A .NET service monitors local network sources, ingests documents like invoices and contracts, generates embeddings via a local LLM, and stores them using SQL Server's vector data type.

Introduced in SQL Server 2025, optimized locking improves transaction locking mechanism to reduce lock blocking and lock memory consumption for concurrent transactions. It's composed of two primary components: transaction ID (TID) locking and lock after qualification (LAQ).

Introduced in SQL Server 2025, optimized locking improves transaction locking mechanism to reduce lock blocking and lock memory consumption for concurrent transactions. It's composed of two primary components: transaction ID (TID) locking and lock after qualification (LAQ).

Introduced in SQL Server 2025, optimized locking improves transaction locking mechanism to reduce lock blocking and lock memory consumption for concurrent transactions. It's composed of two primary components: transaction ID (TID) locking and lock after qualification (LAQ). In this session we'll look into how this works and how we can use it.

Accelerated database recovery is not a well known feature, even though it's been around since SQL Server 2019. It improves database availability, especially in the presence of long-running transactions, by redesigning the database engine recovery process and it has been improved with every new version.

Introduced in SQL Server 2025, optimized locking improves transaction locking mechanism to reduce lock blocking and lock memory consumption for concurrent transactions. It's composed of two primary components: transaction ID (TID) locking and lock after qualification (LAQ).

Accelerated database recovery is not a well known feature, even though it's been around since SQL Server 2019. It improves database availability, especially in the presence of long-running transactions, by redesigning the database engine recovery process and it has been improved with every new version.

Often times we want to know who did what, but out of the box the auditing functionality doesn't do much. In this session we'll take a look at the actual Audit capabilities of SQL Server using the Extended Events infrastructure and a few ways to do it without that infrastructure.

“It is much easier to trick/force someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s sec

“It is much easier to trick/force someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s secrets. The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to socially engineer you.

In today's world the chances of having data in a single language are slim to none. Your customers speak and write many languages with many different letters. Once you get to talking or thinking about characters, collations, encodings, sort orders, diacritics, code pages, etc, a brain melt is what you end up with. In this session we'll look at what all of these things are, how they fit together and how to use them properly as each of them can break your applications in various ways. Since SQL Server 2019 brought improvements in UTF-8 area, we'll look at that as well. Because sometimes it's not enough to just use NChar or NVarChar and thinking everything will be ok.

With SQL Server 2019 Microsoft added a feature to Always Encrypted called Secure Enclaves, which enables us to easily search through encrypted data. In this session we'll take a look at what this feature exactly is, how it works, and how we can utilize it to maximize our data security.