Vincent-Philippe Lauzon’s

Azure, Apps & Data

  • How to copy and backup SQL Databases in Azure

    Let’s say you want a copy of your database for some reasons.  Scenarios might vary.  Maybe you want to bring back production DB to another environment.

    There are at least three ways I could think to do that with the Azure Portal:

    • Copy the Database
    • Restore a version of the Database
    • Backup / Restore the current Database

    Copy...

  • Row Level Security in 3-tiers applications

    Row-Level Security is a great new feature in SQL.  It is already available in Azure SQL Database and will be available in SQL Server 2016.

    This is Cloud-First for you.

    Row-Level Security allows you to forbid a user to see and/or access data they shouldn’t be able to see.  Traditionally this is implemented at the application level, for...

  • I tortured Azure in the Week-End

    In my last blog post, I showed how to author an Azure Runbook to turn VMs up and down.

    In order to test it I did put a schedule where at every hour (e.g. 1:00, 2:00, 3:00, etc.) it would start the VMs and at every pass half hour (e.g. 1:30, 2:30, 3:30, etc.).

    The thing is that I...