A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder. FileTables is a new feature introduced in SQL Server 2012. It's a ...

Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native ...

The Microsoft Information Protection (MIP) service now works with SQL Server data, and can be applied using SQL Server Management Studio (SSMS), according to a Monday Microsoft announcement.

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

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

Over the years, servers have suffered terribly from malicious attacks that users had to take precautions now and then. Because of that, internet users need to determine how to repair a database in an ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

SQL Server, Microsoft's flagship operational database, has been around for over a quarter century now. That has meant successive waves of innovation for the platform, but has also made for ...