Azure One Step at at Time SQL

Download this episode

Download Video

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

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    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

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.