Come join us on Saturday, September 6th for another SQL Bangalore User Group meeting to learn more about Azure Backups, SQL Server 2014 In-memory OLTP, Hybrid cloud scenarios and Power BI.
The session line up is available below.
14:00PM 14:45PM – Azure Backup by Ravikanth
14:45PM 15:30PM – Performance Improvement and In-memory – Balmukund Lakhani
15:45PM 16:30PM – Hybrid Cloud Scenario with SQL Server – Vinod Kumar
16:30PM 17:15PM – Power BI Overview – by yours truly
I will show you how you can use Power BI and Excel can be used to analyze your Facebook data and much more. Register for the event here. As usual, I will post the content used during that day on this blog. Stay tuned in case you are not able to attend in person. And don’t forget to spread the word! Hope to see in person on the 6th!
Microsoft Corporation, Signature Building,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Domlur, Bangalore – 560071
If you have played around with a SQL Server installation on an Azure Virtual Machine, then you will invariably have the need to move a database from an on-premise environment to your Azure Virtual Machine for testing, deployment and a host of other activities which you are involved with on a regular basis at work!
Books Online has complete documentation on this wizard. In this post, we will attempt to understand what happens under the hood. Read on to find out more.
Read the rest of this entry »
The Cloud Adapter is a stateless, synchronous service that receives messages from the on-premise instance of SQL Server. This service is required when you are deploying a database from your on-premise SQL Server instance to a SQL Server deployed on an Azure Virtual Machine.
Cloud Adapter is supported with SQL Server 2012 and higher. On SQL Server 2012, the Cloud Adapter for SQL Server requires SQL Management Objects.
For your SQL Server 2012 installation, you will need the SQL Server Cloud Adapter to be installed. This is available for download from the SQL Server 2014 Feature Pack. The filename that you need to download is SqlCloudAdapter.msi.
When you try to install this on your Azure VM, you might end up with the error message below:
Service cannot be started. System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.SqlServer.SqlEnum, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.
File name: ‘Microsoft.SqlServer.SqlEnum, Version=188.8.131.52, Culture=neutral, PublicKeyToken=89845dcd8080cc91′
at Microsoft.SqlServer.Management.CloudAdapter.Service.CloudAdapterService.OnStart(String args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
The above error message clearly states that the version number that the installer is looking for is SQL Server 2014 i.e. version = 184.108.40.206. You can install this assembly when Microsoft® SQL Server® 2014 Shared Management Objects (SharedManagementObjects.msi) is installed from SQL Server 2014 Feature Pack.
Cloud Adapter for SQL Server