Announcing the ITOpsTalk GitHub repo – A central location for IT/Ops related samples

Today we’re happy to announce the launch of the ITOpsTalk GitHub repo – a place on which the Modern Infrastructure Cloud Advocates team will host Infrastructure samples for anything related to Azure Infrastructure, Hybrid, Windows Server, Containers, e… Continue reading Announcing the ITOpsTalk GitHub repo – A central location for IT/Ops related samples

Lesson Learned #342: Slow communication between our applications and db servers

We used to have service requests that our customers reported slow communications between their applications and db servers. Following I would like to share with you several details to detect where might be the issue that is causing this issue.
 
T… Continue reading Lesson Learned #342: Slow communication between our applications and db servers

Efficiently Generating and Loading 1 Billion Rows into a Relational Database Content in just an hour

The challenge:

To generate and load 1 billion rows of data into a relational database on Azure in a significantly shorter time frame than the previous 72 hours.

The problem:

The initial parallel threads were competing for IO and CPU resources, causi… Continue reading Efficiently Generating and Loading 1 Billion Rows into a Relational Database Content in just an hour

Lesson Learned #341: Index Disabled vs Performance issues

Today, we got a very interesting service request where our customer reported an issue about performance, where they mentioned that they have an execution plan where in staging environment the filter is using Index Seek and production environment is usi… Continue reading Lesson Learned #341: Index Disabled vs Performance issues