A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs. I ...

Based on the expertise of Intelligent Converters specialists gained from a variety of migration projects, this whitepaper reveals best practices, key bottlenecks, and some tips and tricks for ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

With all the cheerleading and the steady drumbeat of new features being released to Azure, it’s easy to lose track of the many cool and valuable new features released in the on-premises version of SQL ...

Don't let an error message or two stop you from getting what you need. Here's a quick trick to keep things running. When building an SSIS package, you probably find ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...