Moar Azure

• Steve Jones - SSC Editor

  SSC Guru

  Points: 720094

  More actions

  June 20, 2020 at 12:00 am

  #3764293

  Comments posted to this topic are about the item Moar Azure

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com

• Sergiy

  SSC Guru

  Points: 109766

  More actions

  June 21, 2020 at 1:25 am

  #3764566

  From what I saw last years, 95% of that increased workload are table scans, hash joins, endless data replications due to horrible indexing strategies and overall dumb database design.

  at least I can see why Microsoft recommend clustered primary key on identity columns - it sells a lot of Asure service.

• John Langston

  SSCommitted

  Points: 1861

  More actions

  June 21, 2020 at 12:56 pm

  #3764585

  The Azure SQL Database world has improved over the last four years based upon what I have observed.  The other day I tried to provision an elastic pool in US North Central and received a message informing me that this was not possible with the particular subscription I was using so went to US Central.  This was the first time I had seen such a message.