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 Is Tsql Function? Users-defined functions are Transact-SQL or CLRS (common language runtime) routines that take parameters, perform actions, such as complex calculations, and return the results ...

The platform runs SQL Server on Kubernetes and directly connects SQL Server to Apache Spark for in-memory machine learning and advanced analytical functions.

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.

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment ...

SQL Server auditing prior to SQL Server 2000 Earlier releases of SQL Server have only one built-in auditing feature: the ability to capture server logins. Under SQL Server 7.0, for example, you ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how.

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

How an old Drawbridge helped Microsoft bring SQL Server to Linux There are certainly risks involved, but a clever research project makes it all possible.