Category Archives: SQL Azure

by

SQL SERVER – Generate Database Script for SQL Azure

When talking about SQL Azure the common complain I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate script which is compatible with SQL Azure.

As above images are very clear I will not write more about them. SQL Azure does not support filegroups. Let us generate script for any table created on PRIMARY filegroup for standalong SQL Server and compare it with the script generated for SQL Azure.

You can clearly see that there is no filegroup in the code generated for SQL Azure. Give it a try and please your comment here about what do you think about the same.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads
by

SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server

SQL Server and SQL Azure are two Microsoft Products which goes almost together. There are plenty of misconceptions about SQL Azure. I have seen enough developers not planning for SQL Azure because they are not sure what exactly they are getting into. Some are confused thinking Azure is not powerful enough. I disagree and strongly urge all of you to read following white paper written and published by Microsoft.

SQL Azure vs. SQL Server by Dinakar Nethi, Niraj Nagrani

SQL Azure Database is a cloud-based relational database service from Microsoft. SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This paper compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities.

The content of this white paper is as following:

  • Similarities and Differences
    • Logical Administration vs. Physical Administration
    • Provisioning
    • Transact-SQL Support
    • Features and Types
  • Key Benefits of the Service
    • Self-Managing
    • High Availability
    • Scalability
    • Familiar Development Model
    • Relational Data Model

The above summary text is taken from white paper itself.

Reference: Pinal Dave (http://blog.sqlauthority.com)

by

SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend

Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career.

In Ahmedabad this event will happen on January 30, 2010. Just like last event we are expecting this time as well the event will have astonishing success and huge response. We will have five tech sessions back to back with lots of interesting and innovative efficient Microsoft products. The details of the sessions for this event is as following.

I will be talking about SQL Azure.

Microsoft SQL Azure Platform provide all the necessary building database blocks to develop and host rich database applications that can service an Internet-scale user population while storing nearly limitless amounts of data.

The venue for this event is Bhaikaka Hall, located at the center of the city. The complete address of the venue is Bhai Kaka Hall, Nr British Library, Nr Law Garden, Navrangpura, Ahmedabad – 380009. Please arrive early to secure your place. Last time we had many users showed up at very last moment and we were not able to accommodate after 300+ count. The onsite registration will start at 9:30 AM on January 30, 2010.

Register for this event here

Reference: Pinal Dave (http://blog.SQLAuthority.com)

by

SQLAuthority News – Download Windows Azure Platform Training Kit – December Update

Note :  Download Windows Azure Platform Training Kit – December Update by Microsoft

I wanted to read some good SQL Azure related to documentation, I tried to do searching online. While searching I landed over Windows Azure Platform Training Kit. This contains lots of SQL Server related content.I downloaded it and started to explore, I suggest if you are interested in Azure Platform you download it as well.

The Azure Services Training Kit 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 Windows Azure platform including: Windows Azure, SQL Azure and AppFabric. The December release includes new and updated labs in addition to information about Microsoft Codename “Dallas”.

This training kit contains lots of Hands On Labs, Presentations and Videos, Demos and Samples and Tools.

Download Windows Azure Platform Training Kit – December Update

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

by

SQLAuthority News – Download – Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)

This release features the SQL Azure provider for Microsoft Sync Framework, a plug-in for Visual Studio 2008 Professional SP1 and the tool SQL Azure Data Sync Tool for SQL Server, all of which simplify using Sync Framework and SQL Azure together.

Download Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

by

SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure.

Download Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

by

SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP: SQL SERVER – Azure Start Guide – Step by Step Installation Guide. For pricing and introduction, please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing. I received many comments times when people are connected to the SQL Azure they receive following error.

Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)


Fix/Workaround/Solution:

1. Close out all the Connect to Server Dialogue
2. Click on the New Query button from the toolbar


3. Enter the following details
Server name: full servername (e.g. (name).database.windows.net)
Login: Your Username (no @…)
Password: Your Password

(optional) 4. Under the options in Connect to Database: type ‘master’ or ‘your own database name’

5. Hit connect

Once you hit Connect, it may give you additional warning, which depends on the server settings. Click OK and ignore all of them. Subsequently, you should be able to connect easily with the server.

If you need any additional details about Azure, I suggest you all to read more about it here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)