Database Recovery

Understanding the Advantages of Query Store in Ms SQL Server 2016

In this article we look at some of the key advantages of Query store in SQL Server 2016 Your wish for a faster and easier way to deal with troubleshooting while working on SQL Server gets fulfilled now in the latest 2016 version that comes with the smart Query Store. As the name suggests, the Query Store features different scenarios where a user can get trouble while working on the server just to simplify the performance. Once enabled, this store automatically picks and even retains a...

Read more »

Temporal Tables in SQL Server 2016 – A Primer

In this article we look at the feature of temporal tables present in SQL Server 2016 For those of you who wish to know about some interesting new features of SQL Server 2016, Temporal Tables are a must to check out! Also, referred to as System Versioned Tables sometimes, these tables have been incorporated in this latest version of SQL to keep the data history in the table automatically. The best benefit of this feature is to have an access to the old data at any moment of time while working...

Read more »

SQL Server 2016 tries to steal a march on Oracle

In this article we look at how SQL Server 2016 is stealing a march on Oracle Microsoft recently launched its much awaited SQL Server Database 2016 with an aim to attract database clients with better features and pricing. Planning to offer more advanced features, hybrid cloud technology and security, the Redmond based IT giant is expected to win over Oracle clients with its SQL Server Database 2016. In fact, with the launch of the latest SQL version that is full of amazing and advanced...

Read more »