(Koen Verbeeck) SQL Server 2016 introduced several enhancements to the Transact-SQL language used by the database engine. This tip will guide you through the most notable changes and additions.

(Pinal Dave) While writing my previous blogs about SQL Server Configuration Manager, I encountered another error. In this blog, we would learn one of the possible causes of error 0x80010108 – The object invoked has disconnected from its clients.

(Pinal Dave) While playing with my virtual machine, I encountered an interesting error. In this blog we would learn how to fix error cannot connect to WMI provider [0x80070422] while launching SQL Server Configuration Manager.

(Pinal Dave) CONVERT function can be used to change the format of DATE to various formats like MM/dd/yyy, dd/MM/yyy, yyy/MM/dd, etc.

(James Serra) At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage.

(Chris Webb) The short answer: no.

(Anoop Kumar) In this article we will discuss options to make Microsoft SQL Server (MS SQL Server) available on Amazon Web Service (AWS).

(Koen Verbeeck) Temporal tables – not to be mistaken with temporary tables – were introduced as a new feature in SQL Server 2016. Temporal tables, also named system-versioned tables, allow SQL Server to automatically keep history of the data in the table.

(Kenneth Fisher) I was asked an interesting question the other day.

(Pam Lahoud) Next up for new Storage Engine area features in SQL Server 2019 is an update to the sp_estimate_data_compression_savings stored procedure to add support for both columnstore and columnstore archive compression.