Microsoft Teched 2013 Keynote

Welcome to Teched 2013 We're starting off with some type of James Bond video. Chase scene with a really cool car. Not quite French Connection, but good. OK, that was, if a little ballsy, "you'll never crack it" Jeez, how to upset people. And the car from the video drives out on stage. And that is Brad Anderson arriving. Guy7 looks like he does crossfit. "We spend our time making other people great" He's laying out the path of the future and, shock of shocks, he said SQL. Out loud. On stage. Twice. That's pretty cool. SQL Server often feels like a red-headed step child. Iain McDonald, comes out to introduce information about Windows Core. The OS covers everything from the phone to tablets to xbox to your servers. The…
Read More

Azure does Powershell too

Azure, PowerShell
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of commandlets for Azure and Azure SQL Database. Here's the link to get you started and the basic documentation. After that, it's a little tricky to know for sure what's required. Follow the instructions on the link to get the basic set up done, and then I'll show you just a little bit about how you can manage your Windows Azure SQL Database through PowerShell. First up, you need to set up a context, which is basically a connection to your Azure server. This requires very specific objects. The code below outlines what you need: [crayon-5a6cf5812c45f182213822/] Nothing to it really. You create the PSCredential, your WASD SQL login, proving your user…
Read More

Execution Plans in Azure SQL Database

Microsoft has stated pretty clearly that they're putting code on Azure first, ahead of the desktop. Which makes one wonder when we're going to start to see some of this cool stuff within SSMS. What cool stuff you ask? Well, let me explain. Let's start with a query: [crayon-5a6cf5812dce8725021495/] When I run this on Windows Azure SQL Database (WASD) I get the following execution plan: Kind of weird, kind of useful, right? First thing new that I can do is zoom in using that slider bar you seen in the lower left and then graphical part of the plan looks like this: The icons have shifted into the corner and you get the costs of every operator. You also get text describing what the operator does. You can scroll around…
Read More