Whenever a query is run for the first time in SQL Server, it is compiled and a query plan is generated for the query. Every query requires a query plan before it is actually executed. This query plan is stored in SQL Server query plan cache. This way when that query is run again, SQLContinue reading “Understanding SQL Server query plan cache”
Category Archives: Uncategorized
Microservices Design Patterns
A microservice is a largely independent application component tasked with a specific function in a system. This type of setup has many advantages, such as the ability to write any service in a different technology and deploy them independently as well as performance boost and more. But it also comes with quite a few challenges,Continue reading “Microservices Design Patterns”
Migrate the Azure Database from one Azure Sql server to another
Presently we had a chance to restructure all the components in the Subscription and beyond subscriptions and resource groups. Actually there are 4 ways to do so… one is via SQL, Azure Portal, Azure Powershell and Azure CLI. I tried the first option, that was time consuming. The second one is via SQL, the mostContinue reading “Migrate the Azure Database from one Azure Sql server to another”
My First Blog Post
Be yourself; Everyone else is already taken. — Oscar Wilde. This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.
Introduce Yourself
Its Me Rama, Who is actually myself. I will speak more on the Technology :). I am from .NET background but also interested in various flavours of technology. You can expect my learnings here. And also can reach me for any Tech related support.
Ramalakshmi's Tech Blog 