SQL Server Management Studio and SQL Azure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Moore » SQL Server Management Studio and SQL Azure

33 posts, Page 2 of 4

««1 2 3 4 »»»

SQL Server Management Studio and SQL Azure

Rate Topic

Display Mode

Topic Options

Author

Message

sherif.ahmed

Posted Wednesday, December 09, 2009 9:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 11:12 AM
Points: 6, 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.

Post #831516

jlgrock

Posted Wednesday, December 09, 2009 9:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 08, 2010 2:54 PM
Points: 4, 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.

Post #831550

Nitya

Posted Wednesday, December 09, 2009 7:22 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:59 AM
Points: 389, Visits: 140

The Jan Bill is going to be a informational Statement (Warning)
Feb 2010 onwards it will be actually billed

Post #831948

David Luu

Posted Thursday, December 10, 2009 12:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 1:32 PM
Points: 7, 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.

Post #832026

sherif.ahmed

Posted Thursday, December 10, 2009 3:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 11:12 AM
Points: 6, Visits: 16

In theory you should be able to connect via any TDS based client (JDBC, ODBC, OLEdb) I believe.

Post #832077

David Luu

Posted Thursday, December 10, 2009 12:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 1:32 PM
Points: 7, 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.

Post #832495

David Luu

Posted Thursday, December 10, 2009 12:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 16, 2009 1:32 PM
Points: 7, Visits: 15

Just tried it with QueryExPlus using the ODBC connection and that works.

Post #832508

Slick84

Posted Thursday, December 10, 2009 12:53 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163

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

Post #832535

Slick84

Posted Thursday, December 10, 2009 1:40 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163

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

Post #832574

Jack Corbett

Posted Thursday, December 10, 2009 3:32 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 10,571, Visits: 11,871

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

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

Post #832628

« Prev Topic | Next Topic »

33 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions