Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

SQL Server Management Studio and SQL Azure Expand / Collapse
Author
Message
Posted Wednesday, December 9, 2009 9:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, December 9, 2009 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 8, 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
Posted Wednesday, December 9, 2009 7:22 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:49 PM
Points: 389, Visits: 154
The Jan Bill is going to be a informational Statement (Warning)
Feb 2010 onwards it will be actually billed
Post #831948
Posted Thursday, December 10, 2009 12:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, December 10, 2009 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, December 10, 2009 12:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, December 10, 2009 12:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, December 10, 2009 12:53 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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!


--
Post #832535
Posted Thursday, December 10, 2009 1:40 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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


--
Post #832574
Posted Thursday, December 10, 2009 3:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:19 PM
Points: 10,342, Visits: 13,347
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 »

Add to briefcase ««1234»»»

Permissions Expand / Collapse