September 19, 2017

While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency  of powershell.  Building off of my previous posts, I'm going to provide a few powershell commands to login and create a new Azure SQL Database.

The first step allows you...

July 24, 2017

Azure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database.

Geo-Replication

Now, if there is an outage covering the entire server region, you can use the Geo-Restore feature or the Geo-replicati...

July 10, 2017

One of the great things about Azure is that backups are automated as part of the service.  Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region". 

The backup schedule is as follows:

Full: Weekly

Differential: Hourly

Transacti...

June 30, 2017

Going to the Azure Portal, creating our first SQL Database.

June 27, 2017

 If only I could upload my brain to the cloud. BaaS anyone?

What is Database as a Service (DaaS)?

Azure SQL Database is Microsoft's version of DaaS.

DaaS is a cloud service in which the service provider manages the operating system and database software. In addition to th...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle
  • Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle