Posted by Alin Irimie
on March 23, 2010
Awesome post on how to troubleshoot SQL Azure connectivity by SQL Services Team, helping you to understand some of the common connectivity error messages that you would see while connecting to SQL Azure as listed below:
- A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
- System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
- Error: Microsoft SQL Native Client: Unable to complete login process due to delay in opening server connection.
- A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Continue reading…
Posted by Alin Irimie
on October 27, 2009
Today Amazon released its answer to SQL Azure, the hosted cloud database offered by Microsoft. The newest service form Amazon, the Amazon Relational Database Service, or Amazon RDS for short, now in beta, makes it easier for you to set up, operate, and scale a relational database in the cloud. You get direct database access without worrying about infrastructure provisioning, software maintenance, or common database management tasks.
Using the RDS APIs or the command-line tools, you can access the full capabilities of a complete, self-contained MySQL 5.1 database instance in a matter of minutes. You can scale the processing power and storage space as needed with a single API call and you can initiate fully consistent database snapshots at any time.
Continue reading…
Posted by Alin Irimie
on April 01, 2009
No more invitation codes needed for .NET Services and SLQ Services. Just go to http://portal.ex.azure.microsoft.com/ and press the Signup button. The following services will be provisioned:
- Microsoft® SQL Data Service
- Microsoft® .NET Service Bus
- Microsoft® .NET Workflow Service
- Microsoft® .NET Access Control Service
Enjoy!
Posted by Alin Irimie
on February 07, 2009
The Azure Services Training Kit was released the other day. It includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Azure Services Platform.
The February release includes the following updates:
- 19 demo scripts that walkthrough several of the services
- 10 presentations covering the entire Azure Services Platform
- 3 additional hands-on labs for Live Services
This technical content covers services including: Windows Azure, .NET Services, SQL Services, Live Services.
You can find the training kit here.
Posted by Alin Irimie
on November 07, 2008
The SQL Server Data Mining team is working to extend the power and ease of use of SQL Server Data Mining to the Cloud. The goal is to provide services that allow you to build rich, predictive applications without worrying about server infrastructure, and showcase these services with cool applications that give you a glimpse of what’s possible. Check it out! Also, the SQL Server Data Mining team has unveiled a technology preview of Table Analysis Tools for the Cloud - the first glimpse of Cloud-based SQL Server Data Mining! It includes both an Excel add-in and a thin browser-based client.
This site has been designed by the SQL Server Data Mining team to provide the SQL Server community with access to and information about our exciting data mining features.
Posted by Alin Irimie
on October 29, 2008
With the announcement at PDC of Windows Azure, Microsoft started releasing more and more Ruby samples to allow developers accessing the new services. Actually at this year’s PDC I heard so much about Ruby and Ruby on Rails from the mouths of Microsoft employees, making me think that the “R” word is not forbidden anymore on the campus. We found a set of ruby samples for SQL Data Services (SDS), formerly called SSDS. The source is hosted on? GitHub of course! The samples will be available as gems from RubyForge. The samples provided are:
sds-rest - A Ruby library to use the Microsoft SDS REST interface
sds-tasks - A sample application using the sds-rest libraries active-resource adapter
sds-radiant - A modified version of RadiantCMS that uses an experimental active_record adapter to talk to Microsoft SQL Data Services REST interface
Posted by Marcio Castilho
on October 27, 2008
“Huron” provides synchronization capabilities within SQL Data Services to enable occasionally connected applications to easily and efficiently enable content flow through the data hub. It consists of:
- A database in the cloud (SQL Server Data Services) that is used as main hub to store the data that comes and goes through the various endpoints.
- A synchronization service layer that sits in the cloud and implements all the logic required to efficiently enable synchronizing with the various endpoints (local databases systems and databases) through the cloud.
- A database provider on the client that interacts with the local database or database system and the remote service to apply remote changes and send local changes back to the cloud.
The idea behind the project is to synchronize all endpoints (local copies of a database) with a database in the cloud. The database in the cloud acts as a hub and holds the full set of data that is exchanged between the endpoints. This hub also enables users to make changes to the database in the cloud which then are sent to the various endpoints. The current implementation of the service layer uses SQL Data Services as the cloud database.
Read more
