It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody. Actually it can happen cause of many reasons. We`ll try to resolve this issue now.So here is a step by step guide for resetting forgotten sa password.

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-Memory OLTP. In-Memory OLTP (project Hekaton) functionality was designed to expedite the processing of typical OLTP-operation in SQL Server. As you know, server load can be divided into two classes: data collection and analysis of what is collected. The first class of problems called OLTP (On-Line Transactional Processing). It is characterized by a short updating transaction affecting a relatively small number of tables in the database. The second class of problems called OLAP (On-Line Analytical Processing) and is characterized by massive prolonged reading, covers a large number of tables and collecting of them, as a rule, the maximum entries. In-Memory OLTP - fully transactional technology and supports failover.