SQL Azure Disaster Recovery Plan


SQL Azure Disaster Recovery Plan The allure of cost savings, greater flexibility, and more agility, many organizations are eyeing the cloud as an alternative for deploying new applications, including those with high database performance requirements, 72% annual growth rate of cloud-based databases through 2018. We are build up the setup SQL server Cluster in Azure…

Products retiring


Products retiring   On April 12, 2016 the following products will NO longer be supported: SQL Server 2005 .Net Framework 2.0 System Center Data Protection Manager 2006 Visual Studio 2005 Dynamics CRM 3.0 Windows Embedded for Point of Service   On July 12, 2016 the following products will NO longer be supported: BizTalk Server 2006…

MS SQL database backup file


MS SQL database backup file SQL Server 2016 Community Technology Preview 2 (CTP2) through current version). To make your database secured and protective; it helps you to restore your inaccessible files of the main database when any type of corruption or damage occurs. But, what if backup also corrupt, while attempting to restore database from…

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…