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 ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

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 ...

Microsoft announced the general availability of SQL Server 2019 and SQL Server Big Data Clusters at its Ignite conference on Monday. SQL Server 2019 builds on intelligent query processing features ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.