Database Recovery

SQL Server 2016 is miles ahead of its 2012 iteration – What’s New

In this article we give a detailed look at some of the distinctive features introduced in SQL Server 2016 With the launch of the SQL Server 2016 edition, Microsoft has given its users a reason to cheer. Expectedly, the 2016 edition is way more advanced than the previous editions, especially the 2012 edition. The 2016 comes loaded with real time insights along with new security innovations, delivers unequaled in-memory performance, advanced analytics and a lot more. Read on to know more about...

Read more »

Scaling options available for SQL Server – choosing the right one for you

In this article we discuss several options for scaling up a SQL Server implementation The most common problem that arises while working on SQL Server is the storage problem. Often due to lack of space, the operations become slow leading to reduced efficiency. But scaling up your SQL Server is not a very difficult task, and it can be done in more ways than just enhancing your existing hardware. Scaling options available for SQL Server include ‘Scaling up’ and / or ‘Scaling out’...

Read more »

Stretch Database – Basics about its working and Benefits

In this article we would explore the Stretch database feature present in Ms SQL Server in depth Amongst the range of new features launched with the 2016 edition of SQL Server, the Stretch Database comes across as a remarkable option, which offers the users a solution for dealing with extremely large databases. This feature provides a ‘Dynamic stretch’ for the warm data (active data) and the cold data (archived data), to be stretched to Microsoft Azure – a cloud based storage platform...

Read more »