SQL Server 2014 performance & improvements


SQL Server 2014 improvements Vs performance …                   The new performance features in SQL Server 2014 that can help our systems perform more efficiently. There have been some other improvements and features added in this latest version of SQL Server that can also, if used correctly, help improve…

Hive – Hadoop


HIVE is a framework that sits on top of core Hadoop. It acts as a data warehousing system on top of HDFS and provides easy query mechanisms to the underlying HDFS data. Programming MapReduce jobs could be tedious and will have their own development, testing, and maintenance investments. Hive queries,  called Hive Query Language (HQL) are…

Installing Mirror Setup in a SQL Server 2012


SQL Server 2012 in a Mirror Enable SQL Server for high availability by enabling them in a mirror setup, There are two modes of database mirroring – synchronous and asynchronous. With synchronous mirroring, transactions cannot commit on the principal until all transaction log records have been successfully copied to the mirror (but not necessarily replayed…

Memory configuration


Configuration ??? As with security configuration, you should make server and database configuration changes with care. Most of the configurable settings in SQL Server work best when left at their default values. You should measure any changes from the defaults for performance and stability impacts in a controlled testing environment before introducing those changes into…

Installing – Setting SSAS 2012


Installing & Setting SSAS 2012 The instructions on how to install the Multi Dimensional version of SSAS 2012. Before proceeding, make sure that the Hardware and Software requirements for Installing SQL 2012 are met with req. If the pre-requisites are met, insert the SQL Server installation media and click on the SETUP.EXE file in the…