JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

SQL Window functions are an advanced type of function in SQL. In this post, you will learn about what SQL window functions are and how they can be used or work. What are SQL window functions? SQL ...

Microsoft announced the name and many of the new features in the next release of SQL Server at its Data Amp Virtual Event on Wednesday. While SQL Server 2017 may not have as comprehensive of a feature ...

To me, the biggest surprise announcement coming out of Microsoft's Connect() 2016 conference last week wasn't that Microsoft was joining the Linux Foundation. Instead, it was that SQL Server Next ...

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

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

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

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

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. The geographic distribution of cloud data centers makes it ...