Database Recovery

Still hanging on to SQL Server 2005 with your dear life – Upgrade Now

In this article, we will discuss why it's so important for all users to upgrade SQL Server 2005 to new editions. Since its first launch, Redmond based software giant Microsoft has released multiple editions of its SQL Server database application in a periodic manner. But there are still users who are hanging on to the more than a decade old edition of SQL Server; the 2005 edition. The extended support for the 2005 edition ended in early 2016; therefore it was imperative for all users to...

Read more »

Learn How SQL Server 2016 addresses size limitation issues in In Memory OLTP

In this article we give a close look at the jazzed up In Memory OLTP feature present in SQL Server 2016 The In-Memory OLTP feature, introduced by SQL Server in its 2014 addition has been upgraded in the SQL Server 2016 edition. The size limitation in the 2014 edition for memory-optimized tables has now been done away with, meaning that the tables can now be as big as the user wants them to be and can go on till there is enough memory available, this was not possible in earlier editions. The...

Read more »

Comparing SQL Server with Oracle – Key pointers

In this article we look at crucial points of difference between the SQL Server database solutions and the flagship Oracle database Almost all successful businesses today are the ones which have always maintained a proper database with sufficient transactions, client, employee and all other details. There are multiple relational database management software in the market today like MySQL, Ms SQL, Oracle, Sybase etc. But the most used are undoubtedly Oracle and Ms SQL Server. Both of them are...

Read more »