Feeds:
Posts
Comments

Archive for the ‘SQL Azure’ Category

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

Posted in SQL, SQL Authority, SQL Azure, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on January 16, 2010 | 1 Comment »

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)

About these ads

Read Full Post »

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

Posted in SQL, SQL Authority, SQL Azure, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on January 10, 2010 | 1 Comment »

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)

Read Full Post »

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

Posted in SQL, SQL Authority, SQL Azure, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology, tagged on January 9, 2010 | Leave a Comment »

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)

Read Full Post »

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

Posted in Technology, SQL Server, SQL, SQL Query, SQL Error Messages, SQL Tips and Tricks, SQL Authority, Pinal Dave, T SQL, SQL Azure on December 8, 2009 | 6 Comments »

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)

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Azure, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 29, 2009 | 5 Comments »

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

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

Accept the TOU.

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

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

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

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

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.

After the change the settings should look like following image.

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.

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.

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

Read Full Post »

« Newer Posts - Older Posts »