In addition to working on my database sharding presentation I’ve been working on upgrading an ETL framework. In learning this new framework I dug into the business logic as to what the framework was trying to load, looked into all the auditing that was currently captured, and I looked for gaps when packages didn’t perform…
Year: 2013
Migration to Windows Azure SQL Database:Step 4 and 5
Now that you’ve completed analyzing your current database, and worked through that list of items that won’t work with Windows Azure SQL Database (WASD), it’s time to begin testing your new solution. Testing begins with setting up your test instance of WASD, and loading your test data, then you point your application to that new…
Migration to Windows Azure SQL Database: Step 3b
Last time I walked you through how to see if your database will work with Windows Azure SQL Database (WASD) using the Migration Wizard on Codeplex. It’s an easy tool to learn to use, and it answers the question what won’t work if I migrate to SQL Azure. It will even help you perform the…
Migration to Windows Azure SQL Database: Step 3
As promised we’re going to dive into the details on how we would actually migrate the database from your on premise server to Windows Azure SQL Database. We’re going to go over how to do this with the SQL Database Migration Wizard. I’ll be honest, going forward we only use SQL Server Data Tools (SSDT), because you get…
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…
Test Driving Windows 8.1
So the past few weeks have given us a ton of new announcements Windows 2012R2, SQL Server 2014, and Windows 8.1 to name a few. I’ve already spun up a SQL 2014 image in Azure, but I wanted to play with the new SSMS and see if there were any changes. So, as many people…