In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...
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 ...
PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...
Azure SQL vs SQL Server in 2026: compare cost, features, AI, and migration paths, plus when Managed Instance beats Azure VM in one clear framework.
SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...
SQL Server 2025 delivers major performance upgrades alongside licensing changes that can reshape both operational speed and budget strategy. Smarter query execution, refined CPU scheduling, and better ...
SQL Server 2025 is introducing AI-native capabilities alongside new approaches for secure integration with large language models. Enterprises can now run local AI models such as Llama 3 via Ollama for ...
Is it possible to use linked services in MSSQL Server and execute queries if the Distributed Transaction Coordinator is not enabled?<BR><BR><BR><BR>Maybe this should be in the NT forum, but I thought ...
At the Ignite conference today, Microsoft made a series of announcements about Azure databases. It announced a brand-new Azure database called HorizonDB, which is a fully managed PostgreSQL database ...