SQL Server 2016 lost mainstream support this month, on July 13. While you can still run SQL Server 2016 and open support tickets, there will be very few performance updates. In an unusual step, ...

The Linux version of Microsoft SQL Server 2016 v.Next is a viable option for customers who want to deploy the RDBMS on an open source platform, but the early previews lack some features of the core ...

I had the pleasure to spend some time with my old friend at Microsoft, Mark Souza, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other ...

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

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want. It’s not unusual ...

Microsoft’s announcement that it was bringing its flagship SQL Server database software to Linux came as a major surprise when the company first announced this in March. Until now, the preview was ...

SQL Server 2016 is by far the best of the SQL Server family, with its outstanding in-memory performance, new security innovations, and high availability – but that's not all. Database engine rankings ...

Microsoft packed SQL Server 2016 with new advanced features that are supposed to help it compete with a host of other database software. But some of the advanced capabilities in the relational ...

When in March this year Microsoft announced that it was bringing SQL Server to Linux the reaction was one of surprise, with the announcement prompting two big questions: why and how? SQL Server is one ...