Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Management Studio and SQL Azure


SQL Server Management Studio and SQL Azure

Author
Message
sherif.ahmed
sherif.ahmed
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 16
It is live for the purposes of development & deployment.
Its commercial release is next year.

As far as experience. We've been using it for developing concepts and has worked quite well. Yes it does not have all the full blown capabilities like CLR support or GeoSpatial, But given the pace with which Microsoft is moving on this, I won't be surprised to see it soon.
jlgrock
jlgrock
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 48
Now that we have folks using it, can we determine why the database runs extremely slowly? I use this and the Amazon EC2 and they are both horrible on IOPs. It's easy to get started, but hard to use in any form of production environment.
Nitya
Nitya
SSC-Addicted
SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)

Group: General Forum Members
Points: 401 Visits: 160
The Jan Bill is going to be a informational Statement (Warning)
Feb 2010 onwards it will be actually billed
David Luu
David Luu
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 15
Wish Azure worked with 3rd party tools, like SQL Buddy or Query Express.

For QueryExpress v3.9, able to connect to Azure via the SQL login. But not able to select default database for logon. Once logged on, I can at least select query the default views on the master database. Can't switch to other databases though, get error:

"Cannot change database: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database."

QueryExpress had OLE DB option. But guess Azure has no OLE DB connection string?

For SQL buddy, can "test" database connection to Azure for master and custom database. But try to login and get exception.
sherif.ahmed
sherif.ahmed
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 16
In theory you should be able to connect via any TDS based client (JDBC, ODBC, OLEdb) I believe.
David Luu
David Luu
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 15
I guess so, but we'd just have to figure out what the OLEDB and JDBC connection strings would be. MS only provides details for the ODBC connection string.
David Luu
David Luu
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 15
Just tried it with QueryExPlus using the ODBC connection and that works.
Slick84
Slick84
Mr or Mrs. 500
Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)

Group: General Forum Members
Points: 500 Visits: 1163
lcee (12/9/2009)
I'm not sure where the "only works with Vista and Windows Server 2008" statement comes from. SQL Azure connectivity is working fine from my Windows 7 client.


Yeah..same here... works fine using a Windows XP client!

--
Hehe
Slick84
Slick84
Mr or Mrs. 500
Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)

Group: General Forum Members
Points: 500 Visits: 1163
Hey Steve,

You're right about not being able to connect through the main logon box and only by clicking on "New Query" and then logging in through the login box that follows.

However, the problem with this way is I don't see anything in the object explorer.

My question is, should I be seeing something in "Object Explorer" when connected to SQL Azure? Currently I dont and its very annoying as I like to do most of my stuff through the GUI.

Thanks,
Slick

--
Hehe
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11022 Visits: 14858
Slick, you need 2008 R2 tools in order to see anything in the object explorer.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search