I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any…
Category: Microsoft SQL
Microsoft Exam 70-433
I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any…
Best Practices for Building Reliable SQL Azure Database Client Applications
Valery Mizonov has published a paper on SQLCAT, called “Best Practices for Building Reliable SQL Azure Database Client Applications”. The paper discusses his sub-classing of the ADO.NET classes like SqlConnection to handle the retry scenarios associated with SQL Azure. The code is a great stepping-stone; replacing the standard ADO.NET calls with his custom classes. Read…
Developing and Deploying with SQL Azure White Paper
Over at Microsoft they have a white paper that mostly summarizes the articles I’ve been posting on how to develop in SQL Azure. But in a few places they add some information. I wanted to point this paper out to you since it covers how to automatically generate scripts that are SQL Azure compatible from…
TechEd 2010 SQL Azure Summary
SQL Azure Extends to 50 GB With our continued commitment to deliver increasing value in data cloud services to our customers we are happy to announce that SQL Azure database is now extending from 10GB to 50GB size of database storage capacity. With 50GB, SQL Azure service offers customer much higher scalability for their applications…
The Import and Export Data Wizard and SQL Azure
In my previous post I walked through migrating a database from SQL 2008 to SQL Azure. I briefly walked you setting up your account with SQL Azure, creating a database through the Microsoft Services website. I then covered creating tables in SQL Azure, as well as a few of the errors you may encounter along…
Quest’s TOAD Jumps to the Cloud
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….
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…
Microsoft Requests Feedback
The Senior Director of Product Planning for Windows Azure, Mike Wickstrand, is soliciting feedback on how to make Azure even better. There’s even a site with user submitted suggestions at http://windowsazure.uservoice.com/forums/34192-windows-azure-feature-voting. You can submit your own ideas, or read through the list and vote for others’ ideas. I think this is a great idea. If…