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…
Category: Microsoft SQL
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…
Studying for the 70-457:Revenge of the Sith
I passed the exam! Woo hoo! It feels great to have passed this milestone. I want to finish up this series so I can help you pass too! I will say there are some things I feel I need to study more after taking the exam, but I feel that way after every exam. For…
Studying for the 70-457: Part Deux
January 31 is coming up pretty fast ,Just 3 more days, so I want to try to knock out the rest of the study guide in the next couple days so that I’m ready Thursday! Let’s jump right in! Work with Data Query data by using SELECT statements. This objective may include but is not…
Studying for the 70-457
January 31st is the day I’ve set to take the 70-457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1. So let’s jump right in to the materials covered. I’m going to link to the articles I’ve already published. Then, for those I haven’t I’ll be diving in to those I’m…
Changing Job and Database Owners to SA
One of the services we’re trying to flesh out a bit more over at Hive Mind is our standard health check and resolution script. Every DBA has his or her own set of scripts they carry around, either in a file, or a link to where to find it online. Merging the best of all…