Database Recovery

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 »

SQL Server 2016 can drastically improve your Real-Time Analytics Capabilities

In this article we give a quick overview of real time analytic capabilities present in the SQL Server 2016 edition. The SQL Server 2016 edition boasts of an array of exciting features. Out of the new features, the most promising feature to look forward in SQL Server 2016 is its Real-Time Analytics Capabilities. In other words, Microsoft has aimed to provide a mission critical performance to help the users achieve better insights across data and for its hyperscale cloud capabilities. On top...

Read more »