Azure One Step at at Time SQL

Sign in to queue

Description

In this concise session MVP Pat Tormey demonstrates EXACTLY ONE THING Azure,  SQL in Azure.

From the Azure portal dashboard Pat creates a database, configures it for remote access, shows how to get the connection strings, connects to his local SQL Server Management Studio AND Visual Studio 2015 and imports a sample database.

The Azure One Step series is designed to teach you the simplest way to use one Azure Feature.

Tags:

Azure, SQL Azure

Embed

Download

Download this episode

The Discussion

  • User profile image
    PatTormey

    Hey Guys,

    If you want more along these lines click some stars!

    Thanks

  • User profile image
    JulianFrank

    Audio is reallly bad...

  • User profile image
    PatTormey

    Julian,

    I'm happy to fix it but what's wrong? too jumpy?, too quiet?

    Gimme some feedback ad I'll have a shot at fixing it.

    Thanks
    Pat

  • User profile image
    Rick

    Pat,
    Good speed; nice and slow....lots to take in.

    the audio is a bit low but just crank up the speakers..

  • User profile image
    EBouras

    Thanks Pat.  Thanks for the great video.  Azure can be very overwhelming for the newbie and this seems like a solid tutorial to get started.

    I was wondering what the minimal version of Visual Studio is that will perform all the actions that you showed in the video regarding actions on the Azure DB.  We don't need to get VS2015 for this do we?

    Also I dabbled with this a little and found that having extended properties on tables and columns (i.e. description) made the scripting incompatible.  I don't really want to drop and recreate extended properties with every change obviously...  I did this in Management Studio but did not try this in VS, so maybe there is hope?

  • User profile image
    PatTormey

    Hi Ed, Not sure about the extended properties but I use the Free VS 2015 Community Edition and it works. I think I remember that the old version (2013) worked with Azure DB too but it's just easier in VS 2015.
    Pat

Add Your 2 Cents