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…
Vacation +1
This past weekend, I took off for Charleston, SC. I’ve loved this town fora while now. The history, the water, the people. Everything about that place is awesome!. This weekend, Penny made it even more special by marrying me. She makes everything more awesome! Love you babe! Penny posted pictures here I’m sure there’s more…
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…
Introduction to Master Data Services
You find yourself sitting in front of your machine late one evening. Everyone has gone home for the night except for you. You’ve left a scan running to identify all the SQL Servers on your network, and two new ones appear. accountingSQL and humanResourceSQL. You begin to document these two new servers, and notice 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…
SQL Saturday #46, Raleigh, NC
Coming up Saturday, September 18th 2010, SQL Saturday is coming to Raleigh. I missed the one here in Charlotte, back in March. I’m not going to miss this one! If you’re not familiar with SQL Saturdays, they’re a chance to get a ton of information on what’s new with SQL Server, and what’s coming soon….