As you can see, SQL Server 2012 introduces many new and interesting improvements. Many of these functions will be easy to understand for .NET developers since they're borrowed from the .NET Framework.

JSON is not a native data type. A SQL Server column that contains JSON data from the database perspective is a plain string column. ... Unless the new functions of SQL Server 2016 are used, the JSON ...

If you’ve the database backup available and know the time of data deletion, you can use the transaction log with Log Sequence Number (LSN) to recover the deleted data from SQL Server. However if you ...

He offered insights into the product's Always On Availability Groups, Accelerated Data Recovery and scalar functions, too, in this article. SQL Server 2019 is supported on "Windows, Linux, and ...

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...

In the case of these two features, they’ll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server. Dynamic Data Masking in SQL Server 2016.

The big data odyssey of SQL Server 2019, and more data and AI news from Microsoft Ignite; Review: SQL Server 2017 adds Python, graph processing and runs on Linux; Links to Managed Instance and Synapse ...