Troubleshooting SQL Server problems


MS SQL Server problem’s. MS SQL Server is a separate technology, it is often the case that when problems occur, uncertainty arises regarding the root cause, and problem scope is rarely well outlined. Although many of the details here are not specific to SQL Server problems, they are good practices for troubleshooting many types of complex IT…

Cloud based AlwaysOn AG


Cloud based AlwaysOn AG In a SQL Server 2014, it’s possible to create an AlwaysOn Availability Group in Azure. You have two options 1. You can either create an availability that resides entirely in the cloud, or 2nd option. You can create a hybrid environment. AlwaysOn Availability Group in Microsoft Azure. Microsoft Azure, you need the…

Data import from SharePoint 2013


Data import from SharePoint 2013 Online Office 365 using SSIS It’s all about cloud, cloud now-a-days, every1 are going towards the cloud. In this post I will be explaining on how to extract/Import data from SharePoint Lists which is hosted on SharePoint Online of Office 365 using SSIS. There is no direct way to connect to…

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…

Big Data – Hadoop


Big Data – Hadoop Hadoop is an open source software framework that supports data-intensive distributed applications available through the Apache Open Source community. It consists of a distributed file system HDFS, the Hadoop Distributed File System and an approach to distributed processing of analysis called MapReduce. It is written in Java and based on the…

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…