Sammani Palansuriya

Azure SQL Web and Business databases are being deprecated and retired September 2015 so it's time to start planning to upgrade existing Web or Business databases to the Basic, Standard, or Premium service tiers. Upgrading a Web or Business database to a new service tier involves the following steps: Determine service tier based on feature capability Determine an acceptable performance level based on historical resource usage Why does existing performance for my Web or Business database map to the higher Premium levels? Tuning your workload to fit a lower performance level Upgrade to the new service tier/performance level Monitor the upgrade to the new service tier/performance level Monitor the database after the upgrade In this post I will discuss about the point 2 : “Determine an acceptable performance level based on historical resource usage”   How to view the recommended service tier in the new Azure Management Portal New Management Portal Log on to the new ...

  Recently I got a requirement to clear cache value for a given client account. In our systems we have multiple contractors , and we cache some data related to that contractor account. Cache keys are as follows. string .Format( "{ 0} :ServiceTypeList" , clientConfiguration .Code);        string .Format( "{ 0} :PropertyViewModelList" , clientConfiguration .Code);        string .Format( "{ 0} -{ 1} :FaultTypeList" , clientConfiguration .Code,                      serviceType .ServiceTypeID);        string .Format( "{ 0} -{ 1} :LocationList" , clientConfiguration .Code,                      property .PropertyNo); Here some cache keys are based on Client Configuration code, and some have client configuration and some code too. But when we have to clear the cache for a given client account we have only the Client Configuration code. So we used the following approach. 1. Get all Cache Keys private static ConnectionMultiplexe...

  Today almost al the web applications and mobile applications provides search functionality. That is the best way the user could access the data they want to see. Most common way of searching data is giving a search textbox. Further there are many ways of providing richer search experience to the users to make their life comfort when using the application. But providing such search functionality can be challenging for the application developers.It’s not reasonable to expect every development team to build its own search engine. Even installing and running a commercial search engine can be a lot of work. What’s needed is a managed search service that can be used by many different applications, whether they’re running in the cloud or on premises. This is exactly what Azure Search offers. What is Azure Search? Azure Search is a managed service running in the public cloud. You can create a new instance of azure search and use it. Application using azure search can run on Microsoft ...