Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

What would you do...? Have a table (SQL Server 2008) that the user wants to record a fixed 8 character string in. At first glance, a CHAR seems the obvious selection since this value (an 8 ...

Beyond Relational Data SQL Server “Katmai” enables users to do the following: Manage any type of data including relational data, documents, geographic information and XML Work with a consistent set of ...

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.

Q&A Get Started Using .NET Aspire with SQL Server & Azure SQL Database By David Ramel 01/23/2025 Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an opinionated, ...

WIRED Brand Lab | How Microsoft SQL Server 2022, accelerated by 4th Generation Intel® Xeon® Scalable processors, is helping customers take charge of their data, drive insights, and launch ...

An interesting session I attended at the PASS Summit in Seattle was one concerning dealing with VLDBs in SQL Server. It was called “Big Data – Working with Terabytes in SQL Server” presented ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.