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

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

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

Microsoft announced the availability of SQL Server 2016 Service Pack 2 (SP2) on Tuesday. The SP2 release is currently available through the Microsoft Download Center. The publish date is shown as ...

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

Database fans, start your clocks: Microsoft announced Monday that its new version of SQL Server will be out of beta and ready for commercial release on June 1. The news means that companies waiting to ...

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

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 SQL Server is a relational database management system (RDBMS) used in many enterprise-level companies. It provides a secure and scalable environment for storing, managing, and retrieving ...