After I finished evaluating the Storm Events Database from NOAA, I was convinced we needed to look for machine recorded events. When you start poking around the NOAA site looking for radar data, you’ll find a lot of information about how they record this data in binary block format. Within this data, you’ll find measurements…
Tag: Windows Azure
Migration to Windows Azure SQL Database: Step 2
Let’s continue our discussion on what it takes to migrate a database from SQL Server classic to Windows Azure SQL Database (WASD). At this point in the migration we’ve determined that all the access points in our system do have internet connectivity, so they’ll be able to reach our WASD instance. We’re not going to store…
Migration to Windows Azure SQL Database: Step 1
Last time I introduced you to Windows Azure and some of the key features: pay as you go, scalability, and ease of use. These are the three key points I make when I start talking to business owners about why I like Azure, and how it can help their businesses. But before we try and…
On-Premises To Azure Migration
I’ve been presenting this presentation all year. I’ve tweaked it a little after each section. Funny thing is I never blogged that content… So I’d like to take the next few posts to share the content from those sessions in written form. Let’s jump right in. First, what is Azure? You’ll read and hear people…
Windows Azure SQL Database Backups!
If you’ve seen my OnPrem to Azure presentation, then you know one of the two big reservations I had about windows azure was we couldn’t create a transactionally consistent backup of our Windows Azure SQL Database (WASD) instances. The other reservation was the lack of Active Directory integration in WASD instances. Well as of Last…
From “All in” to “Hybrid”
For the past 3 years…up until TechEd 2013, Microsoft was “All in” when it came to the cloud. Their goal was to see all new features and services come to the Azure platform first. The idea was they were going to put everything they had into helping their customers see the cloud as the answer…
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…