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

ctdarrow 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)

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)

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)

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)

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)

sqlazure1 SQL SERVER   Fix : 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

sqlazure2 SQL SERVER   Fix : Error : Invalid object name sys.configurations. (Microsoft SQL Server, Error: 208)
3. Enter the following details
Server name: full servername (e.g. (name).database.windows.net)
Login: Your Username (no @…)
Password: Your Password

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

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

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

5. Hit connect

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

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)

SQL SERVER – Azure Start Guide – Step by Step Installation Guide

As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP.

For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

First it has to be configured online at https://sql.azure.com/

Login using your Live ID

sqlazure1 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Type in invitation code received from Microsoft for CTP. You can request one for your self here.

sqlazure2 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Accept the TOU.

sqlazure3 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Once logged it you will have to create server username and password.

sqlazure4 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Click on my project and it will provide you details about your servername where your data is going to be stored in Azure.

sqlazure5 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

sqlazure6 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Currently default database is master database. Click on ‘Create Database’ button to create new user defined database.

sqlazure7 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

After please switch to Firewall Settings tab and click on checkbox “Allow Microsoft Services Access to this server”.

sqlazure8 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Select the first rule and click on “Edit Rule”. Che the value of to IP range to either your static IP only for security purpose. If due to any reason, you want to leave it open so you can connect to your Azure from any where keep the From IP to 0.0.0.0 and change the to IP to 255.255.255.255.

sqlazure9 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

After the change the settings should look like following image.

sqlazure10 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Now the next step is to connect to SQL Azure from SQL Server Management Studio. When you open SQL Server Management Studio, it opens up the connection window. CLOSE IT!

Now click on New Query.

sqlazure11 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

Once click on new query enter username and password as well the servername noted earlier and click on connect. It should connect fine and new query window with master as default database should be displayed. You can start writing any query in New Query Window and result will be visible in Result Window.

sqlazure12 SQL SERVER   Azure Start Guide   Step by Step Installation Guide

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

SQL SERVER – Introduction to SQL Azure

What is SQL Azure?

In short, SQL Azure is simply a Microsoft branding change. SQL Services and SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based services remain intact. SQL Azure will continue to deliver an integrated set of services for relational databases. The reporting, analytics and data synchronization with end-users and partners also remains unchanged. This makes it most appealing to current users of SQL Server.

SQL Azure is going to be the Next Big Thing from Microsoft. It is just giving SQL Server a new way of doing operations it was doing for long time. Being on cloud, it keeps development relatively simple by keeping the heart of the programming almost the same. Additionally, SQL Azure keeps the goals of SQL Server, i.e. high availability, scalability and security in the core.

Developers can just start developing SQL Azure application locally using SQL Server Express version (http://www.microsoft.com/express/sql/download/), or the CTP version that will be available in August.

Read my complete article here.

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

SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

Microsoft has updated the branding for SQL Services and SQL Data Services. SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database. Changing the name does not change product but it demonstrates tight integration between the components of the service platforms.

As a part of the Windows Azure platform, SQL Azure Database will deliver traditional relational database service in the cloud, supporting T-SQL over Tabular Data Stream (TDS) protocol. SQL Azure Database will be available in two editions: the Web Edition Database and the Business Edition Database.

Web Edition – 2GB of T-SQL based database space for $9.99 per month
Business Edition – 10GB of T-SQL based database space for $99.99 per month.
Customers can also purchase bandwidth for $.10 in and $.15 out per GB

SQL Azure Database is on track to deliver a public CTP in August and ship in the second half of calendar year 2009. In its initial release, SQL Azure Database will support relational capabilities suitable for relational apps, including multi-tenant apps requiring large levels of scale. Future releases of SQL Azure will support advanced features like distributed queries across partitions, and auto-partition. Developers will be able to utilize existing Transact-SQL code to access their data in the cloud.

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