Coming next week, Quest Software plans to release TOAD for Cloud. This will extend its database tools into the Cloud environment. In the first version there will be support for four datasources – Amazon SimpleDB, Microsoft SQL Azure, Apache HBase and any database with an ODBC driver. This will open a world of new possibilities….
Tag: Windows Azure
SQLCMD and SQL Azure
I’ve seen several questions on forums over whether or not you can use SQLCMD with your SQL Azure instance. Well, I’m here to say yes you can! You can even create databases using the command line. Create a .sql file with a script that creates your database, then save the file. CREATE DATABASE databaseName Then…
Microsoft TechEd 2010 SQL Azure updates!
Microsoft TechEd is your chance to learn about cutting-edge insights and gain expertise that will make life easier for you and everyone you work with. You can Immerse yourself in hundreds of learning opportunities and get your questions answered by renowned technology experts. Today, Bob Muglia, President of Microsoft’s Server and Business Tools gave the…
SQL Azure Incompatibilities list
While 99% of what you do in SQL is supported in SQL Azure, there is a small list of things you’ll have to redesign, or at least reconsider before implementing your code on SQL Azure. The following is a list of items that are well documented, but I want to create a more complete list. …
SQL Azure DATETIME Functions
Microsoft SQL has always included a number of date and time functions. These results of these functions were always based on the operating system for the machine the SQL server was running on. But what results will you get when you’re dealing with SQL Azure? The server(s) are all virtual. They are all based on…
Microsoft SQL Azure FAQ
I was searching for news on Microsoft SQL Azure when I cam across this new FAQ. It answers a lot of the questions you may have, and several that I hadn’t thought to ask yet, like “how can you approximate the ROWGUID identifier… turns out using NEWID() will accomplish the same thing. I hadn’t thought…
What is SQL Azure?
I’ve been getting this question or some variant of it for weeks now. Some people are confusing SQL Azure with SQL 2008 R2, and some are thinking it’s SQL 2010. It’s neither of those. It’s its own beast. SQL Azure is a cloud version of the database management system you’ve all come to know and…
SugarCRM Announces SQL Azure Support
After the efforts Microsoft has put into supporting PHP, a major PHP development company has announced they are going to begin supporting Azure. This support, along with the ease of moving from Microsoft’s traditional SQL versions to SQL Azure “was simple and straightforward, taking just a couple weeks of development time, ” according to SugarCRM’s…
How Will Cloud Computing Affect You?
With all this talk about Windows Azure, SQL Azure, Amazon services and moving to the cloud, I start thinking to myself this all sounds somewhat familiar. Not quite Déjà vu, but it feels a little like that. Back in 1998, That ’70s Show went on the air. It made what was old seem new again….
Microsoft Continues to Support PHP
Microsoft continued their support of PHP by releasing a Community Technology Preview for the SQL Server Driver for PHP 2.0. With this release PHP developer can use PHP Data Objects with the SQL Server driver! This will serve to reduce the complexity of targeting multiple databases on the back end. As I’ve noticed before, Business…