Microsoft calls SQL Server 2016 the “biggest leap forward” in the 27-year evolution of the SQL Server database. As we’ll see, despite the excess of hype, the SQL Server 2016 database offers ...

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 highlights of the newest version of Microsoft’s SQL Server 2016 take security and visibility upgrades of earlier versions and move toward availability, simplicity, and consistency. With only a few ...

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

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 SQL Server Licensing can be a headache. In fact, over 80% of SQL instances are licensed incorrectly. As a business owner or IT specialist, it can be hard to tell which configuration is right ...