Murali Krishna

Add Proxy URI to Script Add the code below to the top of your Azure PowerShell script to define a proxy URI that your script can use for communicating with Microsoft Azure.  Depending on your proxy scenario, the value you use for the $proxyString variable may be different in your environment.  In the example below, I’m specifying the proxy URI value that’s commonly used with Fiddler. $proxyString = "http://127.0.0.1:8888" $proxyUri = new-object System.Uri($proxyString) [System.Net.WebRequest]::DefaultWebProxy =     new-object System.Net.WebProxy ($proxyUri, $true) Add Proxy Credentials to Script If the proxy configuration used in your environment requires authentication, you can also add one of the following lines to your script – depending on the type of authentication credentials required. To use Windows credentials for proxy authentication, you can add … [System.Net.WebRequest]::DefaultWebProxy.Credentials =     [System.Net.Cred...

You already have Walmart app in your mobile, and live near a store where "Walmart Pay" is accepted. But you don't see Walmart pay option in the app. All you have to do is, Select "Your Store" (Your default walmart store address in the app) and update it to the one that accepts Walmart Pay. Now you have toggled the feature on and ready to try!

While creating a cloud service project, this error kept popping up. Just remove the diagnostics file  - diagnostics.wadcfgx and restart the application. Now I can access the cloud service configuration. 

Vlookup approximate match = TRUE almost never works because it's not what it sounds like. For matching a dataset with another, there is an add-in called Fuzzy lookup. http://www.microsoft.com/en-us/download/details.aspx?id=15011 It is very simple to use and allows us to set threshold to find similarity. It gives required results with 90 to 95 percent accuracy. I set my thresholds at 0.8 most of the time, anything below, it gives data that I don't want and above that, it misses some vital information. Finding the sweet spot also depends on the data being compared and acceptable level of accuracy.  

UI notification for windows services is not directly possible. Typically event log can be updated with windows service.  UI notification can be achieved with another application that consumes windows service to give notifications.

 UPDATE scrcrd SET scrcrd.sku_health = skrev . sku_health FROM tbl_SLM_Scorecard scrcrd JOIN tbl_SLM_SKU_Review skrev ON scrcrd . material = skrev . material and scrcrd . month_yr = skrev . month_yr where scrcrd . month_yr = '2015-01-31' and skrev . material is not null and skrev . sku_health <> scrcrd . sku_health

SQL: Scale Up vs. Scale Out Check Description Optimize the application before scaling up or scaling out. Address historical and reporting data. Scale up for most applications. Scale out when scaling up does not suffice or is cost-prohibitive. Schema Check Description Devote the appropriate resources to schema design. Separate online analytical processing (OLAP) and online transaction processing (OLTP) workloads. Normalize first, denormalize later for performance. Define all primary keys and foreign key relationships. Define all unique constraints and check constraints. Choose the most appropriate data type. Use indexed views for de...